Capturing Rejected Rows in DB2/UDB API stage

SAMEENA · Post by **SAMEENA** » Thu Nov 02, 2006 4:59 am

Hi all,

I am working on parallel jobs.I need to capture the rejected records in a sequential file.The target stage that I am using is DB2/UDB API.
Please help me out.

Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 02, 2006 8:19 am

Search can be your friend. You are not the first to have had this requirement.

SAMEENA · Post by **SAMEENA** » Thu Nov 02, 2006 10:51 pm

Hi Ray,
I have searched for it.I could get information about capturing rejected rows in DB2/UDB Enterprise stage and not in DB2/UDB API stage in parallel jobs.

What all I could gather is for DB2/UDB API stage , information regarding rejected records is captured in log,but my requirement is to capture the entire record in a sequential file.

Please let me know where to look for it.

Thanks

kumar_s · Post by **kumar_s** » Fri Nov 03, 2006 4:36 am

Hi Sameena,
Check right-click and draw a reject link to the sequential file stage.
What stops you from using DB2 Enterprise stage stage, where you have option to collect the reject records and the reject code.

SAMEENA · Post by **SAMEENA** » Fri Nov 03, 2006 4:59 am

Hi,
I have tried using a reject link.But no record got populated in the sequential file(reject file), despite the fact that there were 10 records which got rejected by the target database because of database constraints.

I cannot use DB2/UDB Enterprise stage as we don't have create table privelege on target tables which is a prerequisite for using this stage.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 03, 2006 9:41 am

One job in a sequence (processing 0 rows) to create the table, a second job to populate it? That would allow you to use the DB2 Enterprise stage to take full advantage of parallelism.

tagnihotri · Post by **tagnihotri** » Mon Nov 06, 2006 11:52 pm

I have faced the same issue of priveleges! sometimes dba's are really I tried my best to justify but always got a big NO

Now I have implemented the same using transformer before the db2 API stage!

SAMEENA wrote:Hi,
I have tried using a reject link.But no record got populated in the sequential file(reject file), despite the fact that there were 10 records which got rejected by the target database because of database constraints.

I cannot use DB2/UDB Enterprise stage as we don't have create table privelege on target tables which is a prerequisite for using this stage.