When i try to insert/update into RedBrick DB DataStage generates warnings as (for each row inserted/updated)
DSD.BCIPut call to SQLExecute failed
0 Rows affected.
but actually the rows are inserted into the table with proper datatype and time stamp.
what could be the problem that generates this warning
DSD.BCIPut call to SQLExecute failed
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That is a very annoying warning. Red Brick generates a warning if you execute an UPDATE statement that processes 0 rows. DataStage logs that warning.
I have never found a workaround for it. The only "solution" is to intercept that particular warning in the controlling job sequence and bypass it when considering whether all jobs in the sequence were successful.
I have never found a workaround for it. The only "solution" is to intercept that particular warning in the controlling job sequence and bypass it when considering whether all jobs in the sequence were successful.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.