cancel
Showing results for 
Search instead for 
Did you mean: 
0 Kudos

Extend DB2 datatype support

Some DB2 data types seem to be unable to retrieve using the DB2 connector. Examples of this are some timestamp formats, and binary formats.

 

Timestamp:

Retrieving data stored in a TIMESTAMP (9) WITH TIME ZONE column, leads to the following error:

"body": {

    "status": 400,

    "message": "Microsoft Db2 Client: Type not supported: 182 SQLSTATE=HY000 SQLCODE=-343 SQLSTATE=HY000 SQLCODE=-343\r\n     inner exception: Microsoft Db2 Client: Type not supported: 182 SQLSTATE=HY000 SQLCODE=-343 SQLSTATE=HY000 SQLCODE=-343\r\nclientRequestId: c68da4f9-9f44-4389-8e07-f4f55ffca9c0",

    "error": {

      "message": "Microsoft Db2 Client: Type not supported: 182 SQLSTATE=HY000 SQLCODE=-343 SQLSTATE=HY000 SQLCODE=-343\r\n     inner exception: Microsoft Db2 Client: Type not supported: 182 SQLSTATE=HY000 SQLCODE=-343 SQLSTATE=HY000 SQLCODE=-343"

    },

 

Binary:

Retrieving data stored in a VARBINARY column, does not lead to an error. However, the content of what is returned seems to be the content of another column in the same table. I expected (or at least hoped) that it would have returned some representation (hex/base64/something else) of the binary data.

Status: New