SQLCODE detection in Datastage
Posted: Wed Jul 25, 2001 8:38 am
Hello everyone,
We are encountering a problem detecting the error code returned from oracle . I have ellaborated the details below. If anyone has experience with this can you please help us ?
Software :
----------
Oracle 8.1.6 on NT
Ardent Data Stage designer 4.1
What we are doing
----------------------
- Read records from a flat file
- Insert into a table which is an OCI8 stage
- There is one transformer stage in between the flat file and the target OCI8 stage
- Want to detect the error code returned (sqlcode)
- We examine the following Link variables
insert_into_fact.DBMSCODE
insert_into_fact.SQLSTATE
Both these variables are not populated
- We notice the error codes in the log files
- Example : ora-0001 unique constraint violation . This
is noticed in the datastage job log. We
expected the DBMSCODE and/or SQLCODE to be populated. But it is not Our questions
--------------
- How do we detect any non zero sqlcode returned by the Oracle rdbms from Datastage when using OCI8 ?
thanks and regards,
derick
_________________________________________________________
For Rs. 2,000,000 worth of Aptech scholarships click below http://events.rediff.com/aptechsch/scholarship.htm
We are encountering a problem detecting the error code returned from oracle . I have ellaborated the details below. If anyone has experience with this can you please help us ?
Software :
----------
Oracle 8.1.6 on NT
Ardent Data Stage designer 4.1
What we are doing
----------------------
- Read records from a flat file
- Insert into a table which is an OCI8 stage
- There is one transformer stage in between the flat file and the target OCI8 stage
- Want to detect the error code returned (sqlcode)
- We examine the following Link variables
insert_into_fact.DBMSCODE
insert_into_fact.SQLSTATE
Both these variables are not populated
- We notice the error codes in the log files
- Example : ora-0001 unique constraint violation . This
is noticed in the datastage job log. We
expected the DBMSCODE and/or SQLCODE to be populated. But it is not Our questions
--------------
- How do we detect any non zero sqlcode returned by the Oracle rdbms from Datastage when using OCI8 ?
thanks and regards,
derick
_________________________________________________________
For Rs. 2,000,000 worth of Aptech scholarships click below http://events.rediff.com/aptechsch/scholarship.htm