DSXchange

I want to know where the information about the rejected data of the "Reject link" will get stored in the Datastage repository.
I mean which datastage tables this information is present and how can i access those tables?


Please provide inputs to this..

Any help is appreciated...

What particular information?

The fact that the reject link was used is a warning entry in the job log. The row count on any link is stored in one of the records in the status table for the job.

Both items of information are retrievable using the DataStage API, so there is no need to know precisely where the information is stored, which location may change over time.

Thanks ray for the reply.
I'm having a reject link to the sequential file stage, i want to know why the data got rejected?

So where this information is present in any Datastage tables or files and how can i access it?

For e.g:
The record got rejected due to invalid number, whether this information will get stored in Datastage tables or not? And what's the path for it?

Please provide inputs to this..

it will be suffixed to the last column of the rejected link record.
it will be error number only.

The reason for rejection is NOT stored in any DataStage repository table.

thanks ray..