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
Reject Rows from DB2 API stage.
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
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.
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.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)
hey us1aslam1usus1aslam1us wrote: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.
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.
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
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
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
You need to specify the reject link from the same transformer which feeds the DB2 stage.
The constraint of the reject link will be
where DBLINK is the link name going to your DB2 stage.
The constraint of the reject link will be
Code: Select all
<<DBLINK>>.REJECTED
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
DSguru2B wrote:You need to specify the reject link from the same transformer which feeds the DB2 stage.
The constraint of the reject link will bewhere DBLINK is the link name going to your DB2 stage.Code: Select all
<<DBLINK>>.REJECTED
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: