Reject from Oracle target

ankita · Post by **ankita** » Tue Apr 15, 2008 6:04 am

Hi,

We are facing a problem while testing reject criteria from target ODBC stage.
Our job has a ODBC stage (used as Oracle target) and reject mode is on. It's rejecting the records properly when kept in 'Upsert' mode, but not rejecting any data to file when target is in 'Insert only' mode.
Testdata was prepared with Null in not Null field to test the reject handling.

Has anyone faced similar problem in latest version of DataStage ?
Please suggest.

Thanks,
Ankita

BugFree · Post by **BugFree** » Tue Apr 15, 2008 6:10 am

1) In 'Insert only' mode is the rejects property set to true?
2) With 'Insert only' mode and rejects is there any entry in the log about 'bad' file? It is generally created in the scratch disk with the rejected records.

ankita · Post by **ankita** » Tue Apr 15, 2008 6:18 am

Yes, Reject criteria is ON in both the cases. When the job is run in 'Insert only' mode then 2 records are getting rejected as per job statistics, where 1000 records are supposed to be rejected.
Also not able to see these 2 records from unix, or view data.

bkumar103 · Post by **bkumar103** » Thu Apr 17, 2008 1:56 am

why those records need to be rejected, is it because of duplicate primary key.