Issue with DRS stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sumesh.abraham
Participant
Posts: 153
Joined: Thu May 11, 2006 1:52 am
Location: Bangalore

Issue with DRS stage

Post by sumesh.abraham »

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?
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”