warnings during the Load

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
arunkumar1111
Participant
Posts: 19
Joined: Sun Jun 29, 2008 10:19 pm

warnings during the Load

Post by arunkumar1111 »

Hi

I have a dataset and i'm loading the records from transformer to a db2 table

dataset---->Transformer-------->Db2Table.

The table is in Clear and Insert Mode
When the table is empty, the records are loading correctlt. When there is record it gives the warning
Table1,0: Warning: JobLoad: SQLExecDirect: Returned success with info for statement 'DELETE FROM Table1. See following DB2 error for details.

Can any one help to solve this warnings
Thanks and Regards
Arun
Known is a drop and Unknown is an Ocean
DS_FocusGroup
Premium Member
Premium Member
Posts: 197
Joined: Sun Jul 15, 2007 11:45 pm
Location: Prague

Post by DS_FocusGroup »

So did you see the error tables for details ?
arunkumar1111
Participant
Posts: 19
Joined: Sun Jun 29, 2008 10:19 pm

Post by arunkumar1111 »

The Tables are getting loaded. But still the warnings exists.
Thanks and Regards
Arun
Known is a drop and Unknown is an Ocean
DS_FocusGroup
Premium Member
Premium Member
Posts: 197
Joined: Sun Jul 15, 2007 11:45 pm
Location: Prague

Post by DS_FocusGroup »

yes but there are some going in the error table too ?
Post Reply