Hi Puvin,
Try to add Exception block to this piece of code and try to catch the exception.
-Nagesh
Search found 124 matches
- Mon Aug 01, 2005 6:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: User defined SQL
- Replies: 8
- Views: 4827
- Sun Jul 31, 2005 7:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Can we know the Constraint Name which was Violated
- Replies: 4
- Views: 1141
- Fri Jul 29, 2005 1:21 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Can we know the Constraint Name which was Violated
- Replies: 4
- Views: 1141
Can we know the Constraint Name which was Violated
Hi All,
Is there a way to get the Name of the Oracle Constraint which was violated during the load process?
Is there a way to get the oracle error message and not just the DBMS Code. (for example I get ora-0001, but i dont get the message Unique constraint violated)
Nagesh
Is there a way to get the Name of the Oracle Constraint which was violated during the load process?
Is there a way to get the oracle error message and not just the DBMS Code. (for example I get ora-0001, but i dont get the message Unique constraint violated)
Nagesh
- Fri Jul 29, 2005 8:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error Handling in Datastage
- Replies: 1
- Views: 1625
Error Handling in Datastage
Hi ! I am developing a datastage job which will read from Flat files and database tables, do lookups and then populate the target. The logic and the Reject row handling (lookup not found) is already in place. I was wondering if I could capture possible errors like File not available, File cannot be ...