topic Guess Schema and Guess Query error with tDB2Input with tables with CLOB or BLOB fields in Talend Studio

Guess Schema and Guess Query error with tDB2Input with tables with CLOB or BLOB fields

Anonymous — Sat, 16 Nov 2024 09:27:11 GMT

Hi,

I've a problem with DB2 tables with CLOB fields for guessing query and schema. I've a famous error message :

com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-270, SQLSTATE=42997, SQLERRMC=63, DRIVER=3.66.46

DB2 users know this message because this error occurs when your trying to use scrollable cursor on tables with CLOB fields.

Is there a patch or workaround for this problem other than typing data manually ? The way Talend reads DB2 results is not compatible with tables with CLOB (reproduced on Talend BD 6.0 and latest 6.4)

Thank you

Eric

Re: Guess Schema and Guess Query error with tDB2Input with tables with CLOB or BLOB fields

Anonymous — Thu, 03 Aug 2017 16:27:52 GMT

I'm not aware of a patch for this, but you should be able to workaround this by removing your clob columns from your query and then using the guess query and guess schema options. If this works successfully, you can manually add the clob columns back into your query and set corresponding columns in your metadata (I believe you will need to set them as Object).

I know this isn't a fix, but unless there is a patch I believe it will be either this way or doing it completely manually. Good luck 🙂