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
PROBLEM - INSERTING RECORDS into DB2 UDB API stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 75
- Joined: Thu Nov 27, 2008 10:12 am
PROBLEM - INSERTING RECORDS into DB2 UDB API stage
Last edited by ds_search2008 on Thu Nov 27, 2008 10:55 am, edited 1 time in total.
-
- Participant
- Posts: 75
- Joined: Thu Nov 27, 2008 10:12 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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 75
- Joined: Thu Nov 27, 2008 10:12 am