Capturing Oracle Error Code From Enterprise Stage

[Gokul]

Hi All,

I have a follwing job design

Code: Select all

OraTable -------->Transformer-------->OraTable 

a> The source & Target are Oracle Enterprise Stages.
b> There are 2 targets, one for good records and other reject table where we will have bad records.

In the reject table , I want to capture the oracle error code for the rejected records.

I found that Enterprise Stage has default sqlcode column which gives error codes only for upsert failure and duplicate records.

I want to capture all the types of Ora errors.
Please provide your inputs on the same.

Gokul

[ray.wurlod]

Once you place a reject link on the Oracle Enterprise stage, DataStage will automatically manage writing sqlcode (the error code) to that reject link. Which errors are you claiming are not captured?