This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Connect DB2 table via ODBC with CLOB or Text datatype.

I am attempting to connect a DB2 table using the following command line:

create table TASKS engine=connect table_type=ODBC block_size=1000 tabname='ISW.TASKS' connection='DSN=DB2_ODBC;UID=user;PWD=password;MODE=SHARE;DBALIAS=SCODS;';

and I receive the following error: ERROR 1105 (HY000): Unsupported SQL type -99

My belief is that because CONNECT is retrieving the table description using ODBC catalog functions and since the DB2 table contains a column that has a datatype of CLOB that Mariadb is throwing the above error.

When I attempt to specify the column definitions for the DB2 table, and define the column as TEXT or BLOB, I receive the following error: SQL Error (1163): Storage engine CONNECT doesn't support BLOB/TEXT columns.

Is there a way to CONNECT a DB2 table via ODBC or Direct Connection to a table that contains CLOB or Text defined columns? I do not have any issue connecting other tables from the DB2 database that do not contain CLOB datatypes.

Answer Answered by Daniel Black in this comment.

Create a bug report listing missing types here: https://jira.mariadb.org/projects/MDEV/issues

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.