When trying to read (or open) a table from an IBM Db2 database (via DI Studio), we get the following errors: ERROR: CLI open cursor error: [IBM][CLI Driver] SQL30020N Execution of the command or SQL statement failed because of a syntax error in the communication data stream that will affect the successful execution of subsequent commands and SQL statements: Reason Code "0x220A"("0100")"". SQLSTATE=58009 ERROR: CLI close cursor error: [IBM][CLI Driver] CLI0108E Communication link failure. SQLSTATE=40003 This is because of 1 specific numeric variable. If we stop reading it, then everything else loads correctly. The numeric variable is likely troublesome because it's stored with the length 38,0 in the source database. Do you have any advice on how we might remedy this? I'm hoping there's some kind of library setting or precode we might use to force the variable into an acceptable numeric format.
... View more