Datastage job not throwing warnings on foreign key violation

Pravenai · Post by **Pravenai** » Fri Dec 14, 2012 1:46 am

Hi,

I created a simple parallel job having three stages:
1) Input - Oracle enterprise stage
2) Transformer
3) Output - Oracle enterprise stage

This job fetches data from a source table and deletes the data from the target table. I have used auto generated delete statement in the target stage.
The delete happens on the primary key value.

I ran he job for a single record. This record was not deleted from the target and it got rejected. In the log statistics I saw the record as rejected. But the job had no warnings.

The reason of rejection was there are some foreign key constraints which prevented this record from being deleted in the datastage job. However my question is datastage doesnot throw up any warnings on foreign key violations? Does it simply reject the record without any warnings?

Is there any environmental variable that would help in my case?

Thanks for the help.

Regards,
PR

ray.wurlod · Post by **ray.wurlod** » Fri Dec 14, 2012 3:38 am

If you capture the reject in a reject link the reject link can also be populated with the error code and error text.

Pravenai · Post by **Pravenai** » Fri Dec 14, 2012 3:43 am

I can capture that through a reject link to a file or dataset. But that would mean this reject file has to be monitored after every run.

My question is can we get the information as a warning in the datastage logfiles itself that a record has been rejected because of foreign key violation? Is this the normal behaviour in case of oracle stage where a record is silently rejected even in case of failure to write into a table?

regards,
PR

Pravenai · Post by **Pravenai** » Fri Dec 14, 2012 10:15 am

I just checked, we cannot use a reject link to an oracle enterprise stage while using delete option. I am using 8.1 version.

Pravenai · Post by **Pravenai** » Mon Dec 17, 2012 12:51 am

I checked the same thing using a server job and it is throwing up warnings which is what I am looking for.

Cannot we have the same functionality in parallel jobs i.e. we get a warning in case of rejected records for deletes?

Thanks for the help.

Regards,
PR

chulett · Post by **chulett** » Mon Dec 17, 2012 8:25 am

Double-check with your official support provider. You may need to upgrade... or perhaps use the Connector stage. Or both.