Reject rows

akrzy · Post by **akrzy** » Mon Feb 21, 2005 9:02 am

Is there any variable that shows a reason why input row was rejected?

Or other possibilty?

Thanks,
Anka

kab123 · Post by **kab123** » Mon Feb 21, 2005 9:08 am

You can Use a number of DS functions like DSGetJobInfo, DSStageInfo, DSlinkInfo etc.. .

akrzy · Post by **akrzy** » Mon Feb 21, 2005 9:18 am

I'm not sure,
because none of this functions tell me what was the reason of the row rejected.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Feb 21, 2005 9:25 am

Unless otherwise it is an error message returned by the call, you may have to identify the reason yourself. This is because the stages in DataStage rejects rows which differs as part of their functionality.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 21, 2005 2:49 pm

Check for link variables such as LASTERR and DBMSCODE.

xlnc · Post by **xlnc** » Mon Feb 21, 2005 5:53 pm

If the row is rejected from any perticular stage then you might want to debug it using a peek stage and establish a reason why , but if it is a target stage then the best way is to go with a user defined update sql and capturing the error code.

chalasaniamith · Post by **chalasaniamith** » Mon Feb 21, 2005 10:22 pm

use peek stage and find out where the row is getting rejected check with the variables,schema u can figure it out from there.

akrzy · Post by **akrzy** » Tue Feb 22, 2005 5:34 am

how can I use DBMSCODE or LASTERR?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Feb 22, 2005 5:44 am

These are values present under Link Variables -> Output. They mentioned the error value from the RDBMS stage. You need to transform this into meaningful values.

akrzy · Post by **akrzy** » Tue Feb 22, 2005 5:47 am

I can'y find LinkVariable in the Deriviation of Transformer Stage

akrzy · Post by **akrzy** » Tue Feb 22, 2005 6:37 am

In the Expression Editor the option "Link Variables >Constants..." is grey.

???

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Feb 22, 2005 7:16 am

Because it is available from Server Edition.

You can set commit size of 1 and pass another link to reject with details of error.

For more information you can search the forum.

DSXchange

Reject rows

Reject rows

Re: Reject rows