With the assistance of our DBA and an IBM developer, we were able to set a parameter in DB2 to filter this warning.
Thanks to everyone for their suggestions!
Search found 4 matches
- Mon May 03, 2004 10:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Update Actions - Clear table, then insert rows
- Replies: 9
- Views: 12001
- Sat May 01, 2004 12:54 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Update Actions - Clear table, then insert rows
- Replies: 9
- Views: 12001
Thanks for the responses. We also have a delete script that we are calling in the 'before job' section of the Data Stage job. In the past, we were able to do a 'clear table, then insert rows' update action without receiving warnings. I was wondering if anyone had discovered a way to use this update ...
- Wed Apr 28, 2004 9:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Update Actions - Clear table, then insert rows
- Replies: 9
- Views: 12001
Update Actions - Clear table, then insert rows
While loading a UDB table from a single input file, using the Update action: clear table then insert rows, I received the following warning: [IBM][CLI Driver][DB2/6000] SQL0513W The SQL statement will modify an entire table or view. SQLSTATE=01504. Is there a way, within Data Stage, to clear the tab...
- Tue Feb 03, 2004 5:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: VOC configuration
- Replies: 2
- Views: 1686
VOC configuration
I am upgrading to Data Stage 7.0 on AIX. I went to the $DSHOME/bin directory and ran uvsh. I received the message 'This directoryis not set up for DataStage. Would you like to set it up?' When I selected 'Y'. I was given 6 options for configuring the VOC: Ideal compatibility, IN2 compatibility, Prim...