Information about the rejected data of the Reject link

verify · Post by **verify** » Wed Aug 06, 2008 11:27 pm

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...

ray.wurlod · Post by **ray.wurlod** » Thu Aug 07, 2008 1:01 am

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.

verify · Post by **verify** » Thu Aug 07, 2008 11:09 pm

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..

keshav0307 · Post by **keshav0307** » Thu Aug 07, 2008 11:31 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Aug 08, 2008 12:13 am

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

verify · Post by **verify** » Fri Aug 08, 2008 12:45 am

thanks ray..