Issue with DRS stage
Posted: Fri May 28, 2010 8:07 pm
Hello,
I am writing records from a sequential file after certain transformations to Oracle table in a 8.1 server job. The DB stage used is DRS stage. The update action is "Clear table then insert rows". Delete operation does not seem to be happening eventhough there is a DELETE FROM <db user>.<table name> in the DataStage log and only an insert is happening.
I have confirmed that there is no privilege issues for the DB user.
In 7.5.3, the same job is running successfully and delete operation happened successfully before insert.
Have anyone of you encounter this issue?
I am writing records from a sequential file after certain transformations to Oracle table in a 8.1 server job. The DB stage used is DRS stage. The update action is "Clear table then insert rows". Delete operation does not seem to be happening eventhough there is a DELETE FROM <db user>.<table name> in the DataStage log and only an insert is happening.
I have confirmed that there is no privilege issues for the DB user.
In 7.5.3, the same job is running successfully and delete operation happened successfully before insert.
Have anyone of you encounter this issue?