DSXchange

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

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.