DSXchange

RMD stage do the following
order of keys should be order of your hash partition
stage -> advanced -> preserve partition select clear.

Chulett, Thank you all for your suggestion. I was surprised to know that there is no way we can transulate an SQL error (such as referential integrity, data integrity, unique constraints.. etc )to a job to Abort. Many ETL tools like Informatica and also DataStage PX too Abort jobs due to an SQL Error.

The requirement is that the DB2 UDB Stage has to cause the job to Abort in case of referential integrity viloation(due to SQL error from the database) while inserting records.

Currently it is just dropping records that have referential integrity violation and job completes successfully.

I am using two jobs to load two DB2 tables A and B. Table A's primary key is forein key in Table B. After loading A, while loading B I am not getting any warnings when there is a referential integrity viloation. The records were dropped/not loaded in B. The job was successful WITHOUT warnings. Is th...

I am using two jobs to load two DB2 tables A and B. A's primary key is forein key in B. After loading A, while loading B I am not getting any warnings when there is a viloation of referential integrity. Only the records were not loaded/ dropped. The job was successful WITHOUT warnings. Is there a se...