Capture Rejected rows along with its description in rej file

kailas · Post by **kailas** » Wed Nov 19, 2008 3:41 am

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

DS_FocusGroup · Post by **DS_FocusGroup** » Wed Nov 19, 2008 4:58 am

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

kailas · Post by **kailas** » Wed Nov 19, 2008 6:14 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Nov 19, 2008 1:26 pm

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

senthilmp · Post by **senthilmp** » Sat Dec 20, 2008 1:43 am

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?

ray.wurlod · Post by **ray.wurlod** » Sat Dec 20, 2008 2:45 pm

The same way as advised to kailas.