Hi All,

I am trying to load data into DB2 tables using Data Management Console. The mapping is a straight forward from DB2 Library1 to Db2 Library2, which exists in the same server.

The flow is valid without any errors, but while running the flow I am getting the following error.

02/17/2012 09:34:42 Server1 The flow is valid. No errors or warnings found.
02/17/2012 09:34:53 Server1 (ICM18122) Request - flows/df_flow1 (Owner: User1) submitted.
02/17/2012 09:34:53 Server1 (ICM18742) target1 type DB2 Existing target
02/17/2012 09:34:53 Server1 (ICM18429) Issuing PREPARE
02/17/2012 09:34:53 Server1 (ICM18743) Starting Load
02/17/2012 09:34:53 Server1 AGGREGATION DONE ...
02/17/2012 09:34:53 Server1 (FOC1400) SQLCODE IS -332 (HEX: FFFFFEB4)
02/17/2012 09:34:53 Server1 (FOC1406) SQL OPEN CURSOR ERROR. : TABLE1
02/17/2012 09:34:53 Server1 (ICM18745) Commit forced at: 1 for 1 row(s)
02/17/2012 09:34:53 Server1 (ICM18041) -- stats for source file
02/17/2012 09:34:53 Server1 (ICM18516) 0 : Row(s) processed by job
02/17/2012 09:34:53 Server1 (ICM18519) 0 : Row(s) rejected due to format error
02/17/2012 09:34:53 Server1 (ICM18372) -- stats for target file: target1
02/17/2012 09:34:53 Server1 (ICM18516) 0 : Row(s) processed by job
02/17/2012 09:34:53 Server1 (ICM18514) 0 : Row(s) accepted by target table
02/17/2012 09:34:53 Server1 (ICM18515) 0 : Row(s) inserted into target table
02/17/2012 09:34:53 Server1 (ICM18517) 0 : Row(s) updated in target table
02/17/2012 09:34:53 Server1 (ICM18518) 0 : Row(s) deleted from target table
02/17/2012 09:34:53 Server1 (ICM18520) 0 : Row(s) rejected due to validation errors
02/17/2012 09:34:53 Server1 (ICM18521) 0 : Row(s) rejected due to no match
02/17/2012 09:34:53 Server1 (ICM18522) 0 : Row(s) rejected because duplicate exist
02/17/2012 09:34:53 Server1 (ICM18808) 0 : Row(s) rejected due to DBMS error
02/17/2012 09:34:53 Server1 (ICM18744) Ending Load
02/17/2012 09:34:53 Server1 (ICM18040) Return Code = 18708
02/17/2012 09:34:53 Server1
(ICM18076) Request: flows/df_flow1 - finished processing
02/17/2012 09:34:53 Server1 (ICM18007) CPU Time : 38


Suggestions and solutions are appreciated.

The SQLCODE is -332 is coming from DB2 so you could start here All SQLSTATE Cause and Recover Information

quote:

Originally posted by Clif:
The SQLCODE is -332 is coming from DB2 so you could start here All SQLSTATE Cause and Recover Information

Thanks for your help Clif and that works.