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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.