Reject Rows from DB2 API stage.

[rajan.n]

Hi,

i have a req like need to collect the reject rows from the DB2 API stage,
for this i have learn from the help that
need to do the folowing:

1)Set the Parameter Array Size property to 1.

2)Use a Transformer stage to redirect the rejected rows.

i have set the parameter array size to 1 in the DB2API stage.

can any body help me how to do the second one i.e redirecting to transformer stage...?

rajan

[us1aslam1us]

If you are designing something like this:

DB2 >>> Transformer >>> Target
V
V
Reject file

On whatever constraints or condition you want to capture the rejected records, define them in the transformer stage for the "reject file" link.

[rajan.n]

If you are designing something like this:

DB2 >>> Transformer >>> Target
V
V
Reject file

On whatever constraints or condition you want to capture the rejected records, define them in the transformer stage for the "reject file" link.

hey us1aslam1us
thanx for the responce,
mu design is like this,


seq--trnsform--DB2
so i need to collect the records rejected from DB2,now my design shud look like
seq--trnsform--DB2--trnsform-seq

i jst want to know how to redirect from DB2 to trnsformer..
once again thnx fro the reply.
rajan.

[Krazykoolrohit]

you can only capture logical rejects in server jobs as far as i know. You cannot have a reject link so you need to define a regular link and guide your reject rows to that link.

and you certanly cannot do anything like seq--trnsform--DB2--trnsform-seq if you want to capture rejects.

My suggestion: Identify what is causing the defects. Is it something in datastage or is it when you load into DB2

[DSguru2B]

You need to specify the reject link from the same transformer which feeds the DB2 stage.
The constraint of the reject link will be

Code: Select all

<<DBLINK>>.REJECTED

where DBLINK is the link name going to your DB2 stage.

[rajan.n]

You need to specify the reject link from the same transformer which feeds the DB2 stage.
The constraint of the reject link will be

Code: Select all

<<DBLINK>>.REJECTED

where DBLINK is the link name going to your DB2 stage.

Thanks a lot for the valuable responces...
my issue has resolved,
as said by guru, given in the trnsformer ( before the DB2) a reject so that i collected teh same from the transformer to a seq file.thnk u.

[ray.wurlod]

The convention here is to mark the thread as resolved.

And there's no need to thank "u" - whoever "u" is did not contribute to the answers.

[rajan.n]

The convention here is to mark the thread as resolved.

And there's no need to thank "u" - whoever "u" is did not contribute to the answers. ...

correct...! my appologise, i thank to the all, for the valuable responces.