Hi

I am updating data from staging table to db2 table and set the target properties as "Insert/Update", If record exsits update the exsisting record
If record not exsits include the record.

But when i run the flow i am getting the below error

05/08/2012 08:35:16 (ICM18122) Request - __WCFEX (Owner: InfoBuild1) submitted.
05/08/2012 08:35:16 (ICM18742) dtravelagent_test1 type DB2 Existing target
05/08/2012 08:35:16 (ICM18429) Issuing PREPARE
05/08/2012 08:35:16 (ICM18743) Starting Load
05/08/2012 08:35:16 (ICM18682) Check set to : 0
05/08/2012 08:35:16 (FOC1400) SQLCODE IS -404 (HEX: FFFFFE6C)
05/08/2012 08:35:16 : [22001] Value for column or variable STATE too long.
05/08/2012 08:35:16 (FOC1740) EXECUTE ERROR : DTRAVELAGENT_TEST1
05/08/2012 08:35:16 (ICM18745) Commit forced at: 1 for 1 row(s)
05/08/2012 08:35:16 (ICM18041) -- stats for source file
05/08/2012 08:35:16 (ICM18516) 1 : Row(s) processed by job
05/08/2012 08:35:16 (ICM18519) 0 : Row(s) rejected due to format error
05/08/2012 08:35:16 (ICM18372) -- stats for target file: dtravelagent_test1
05/08/2012 08:35:16 (ICM18516) 1 : Row(s) processed by job
05/08/2012 08:35:16 (ICM18514) 1 : Row(s) accepted by target table
05/08/2012 08:35:16 (ICM18515) 0 : Row(s) inserted into target table
05/08/2012 08:35:16 (ICM18517) 0 : Row(s) updated in target table
05/08/2012 08:35:16 (ICM18518) 0 : Row(s) deleted from target table
05/08/2012 08:35:16 (ICM18520) 0 : Row(s) rejected due to validation errors
05/08/2012 08:35:16 (ICM18521) 0 : Row(s) rejected due to no match
05/08/2012 08:35:16 (ICM18522) 0 : Row(s) rejected because duplicate exist
05/08/2012 08:35:16 (ICM18808) 0 : Row(s) rejected due to DBMS error
05/08/2012 08:35:16 (ICM18744) Ending Load
05/08/2012 08:35:16 (ICM18040) Return Code = 1740
05/08/2012 08:35:16 (ICM18076) Request: __WCFEX - finished processing
05/08/2012 08:35:16 (ICM18007) CPU Time : 25

There is no duplicate records.

How i can fix this?

Thanks
Madhu

quote:

[22001] Value for column or variable STATE too long.

Did you verify that source values for STATE are not too long for the target column?

Both source and target column format(A30v) is same.

if i change the target properties to delete all data and insert record from memory, its working fine all data's are inserted into the target table

for insert/update only i am getting the error

This message has been edited. Last edited by: Madhumitha,

The error is coming from the database, apparently db2, so be sure that column is actually described as VARCHAR(32).

When insert/update is used the source is matched against the key columns of the target. Is STATE one of the keys?

Code page mismatch?