Search found 16 matches
- Sun May 23, 2004 4:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Capturing rejects in px jobs
- Replies: 5
- Views: 1684
Capturing rejects within Oracle stages
Hi, Was browsing through some posts, .... there is a simple solution, if you have user-defined SQLs 1. Encapsulate your SQL in a PL/SQL block (this will not affect any partitioning as the rejects will be trapped for every array of records) 2. In the EXCEPTION section of this block, insert the reject...