Capturing rejected rows while inserting DB2

major · Post by **major** » Thu Mar 18, 2010 4:08 am

Dear all,

I have a job to insert the data into DB2 DB.
Problem is the rejection file is not capturing the rows which are failed to
insert in the DB even when LinkName.REJECTED is used.

The above procedure is working fine for Sybase db.

Could you please help me in this regard.

Thanks

chulett · Post by **chulett** » Thu Mar 18, 2010 5:17 am

I have zero DB2 experience but let me check a couple of things. What stage are you using? Does it work if your second link has no constraint but instead is simply marked as a 'Reject' link?

major · Post by **major** » Thu Mar 18, 2010 7:16 am

Hi Chulet,

I am using a seq file --> tfm ---> db2 stage.
I am using a hashed file to capture the rejected records which were failed to insert into the db.

I tried with simple reject but of no use

Thanks,

chulett · Post by **chulett** » Thu Mar 18, 2010 7:58 am

Where is this hashed file or any sort of reject link / mechanism in the diagram you posted? How exactly are you trying to do this?

major · Post by **major** » Mon Mar 22, 2010 12:33 am

Sorry , I tried but couldn't able to draw the reject link

Another output link is drawn from the Tfm to a Hashed file(reject file)

A constraint is put for the Hashed file in Tfm like
LinName(of DB2).REJECTED

I even tried with simple REJECT , but of no use.

Please advice

Thanks,

ray.wurlod · Post by **ray.wurlod** » Mon Mar 22, 2010 3:43 am

You need to go into the Transformer stage properties and mark the link as "Reject". It should have no constraint expression, just check the box.