Invalid conversion error

neena · Post by **neena** » 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.

neena · Post by **neena** » Thu Jan 14, 2010 4:48 pm

It resolved when i made the non-key columns as keys in datastage to update the table.