Invalid conversion error
Posted: Thu Jan 14, 2010 4:43 pm
Hi,
I wrote a custom SQL in DB2 stage, in which i am updating two columns based on two other non-key columns
Job design is dataset --> Transformer -- > DB2 API stage.
I am getting following error, is it because i am using non-key column to update the table?
DBMS.CODE=-99999, SQLSTATE=07006, [IBM][CLI Driver] CLI0102E Invalid conversion. SQLSTATE=0700
Could any one please let me know if i am missing something.
I wrote a custom SQL in DB2 stage, in which i am updating two columns based on two other non-key columns
Job design is dataset --> Transformer -- > DB2 API stage.
I am getting following error, is it because i am using non-key column to update the table?
DBMS.CODE=-99999, SQLSTATE=07006, [IBM][CLI Driver] CLI0102E Invalid conversion. SQLSTATE=0700
Could any one please let me know if i am missing something.