PROBLEM - INSERTING RECORDS into DB2 UDB API stage

ds_search2008 · Post by **ds_search2008** » Thu Nov 27, 2008 10:28 am

When I insert rows from pivot to DB2 UDB API stage the performance statistics shows 3 rows. However, only 2 rows are getting inserted into DB2 stage. I tried replacing DB2 API stage with a Data Set stage. I am able to get 3 records as Data set output without any issues.

Data Set : output

col1 col2 col3 col4

100 0 7896 Z
100 21 921.4 Z
100 0 Z

(In row 3 the data Z is inserted under col4 and column 3 is blank)

DB2 Stage : output

col1 col2 col3 col4

100 0 7896 Z
100 21 921.4 Z

The third coloumn is not getting loaded into DB2 stage. Could you please help me to resolve this issue.

Thanks

chulett · Post by **chulett** » Thu Nov 27, 2008 10:33 am

Does your target field in the table allow nulls?

ds_search2008 · Post by **ds_search2008** » Thu Nov 27, 2008 10:51 am

Yes the target field allow null values.

ArndW · Post by **ArndW** » Thu Nov 27, 2008 11:32 am

Allow reject in the DB2 stage and put the reject link out to a peek stage to find out why it is being rejected. If no rejects, then check for your unique primary key - what column(s) are used?

ds_search2008 · Post by **ds_search2008** » Fri Dec 12, 2008 9:04 am

Yes my job is working fine. Thanks a lot for your kind help.