DSXchange

I have a parallel job to load the data into a table in db2 from the sequential file.
some records are getting rejected from the source sequential file itself .My requirement is along with the rejected records
the decription for the rejected rows like( Delimiter for field "SpecialComments" not found; input: {E x t e r n a l}, at offset: 758)
should also be there in the rejected file. can anyone help me in this regard


Here is my job design

Seq file(source file) ------> Transforer ............> DB2 Table


Seq file(source file)..............> Seqfile (Reject file)



Output

The reject file should contain the rejected records along with the description of the rejection

Can anyone help me out on this problem...

Any solution for this problem is really appreciated.............

Thanks
kj

i think you need to check first line columns names to true so you can properly read the records. and if you need to capture the rejects from Db2 i think you can drag a reject link out of it

Hi ,
I have already dragged a reject link to the source and i m getting the rejected rows also in the reject file but the client want rejected rows along with the reason or description of the rejection

Your reject link needs to have sqlcode on it, then you need to look this up against a table of error codes. This could be a sparse lookup back to the DB2 error codes table (for example).

Hi sorry for jumping in,

Am also having the same requirement to capture the error field with the error message.

How to capture the error code in the table?

The same way as advised to kailas.