Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
akrzy
Participant
Posts: 121 Joined: Wed Dec 08, 2004 4:46 am
Post
by akrzy » Mon Feb 21, 2005 9:02 am
Is there any variable that shows a reason why input row was rejected?
Or other possibilty?
Thanks,
Anka
kab123
Participant
Posts: 92 Joined: Tue May 18, 2004 4:05 pm
Post
by kab123 » Mon Feb 21, 2005 9:08 am
You can Use a number of DS functions like DSGetJobInfo, DSStageInfo, DSlinkInfo etc.. .
Thanks
akrzy
Participant
Posts: 121 Joined: Wed Dec 08, 2004 4:46 am
Post
by akrzy » Mon Feb 21, 2005 9:18 am
I'm not sure,
because none of this functions tell me what was the reason of the row rejected.
Sainath.Srinivasan
Participant
Posts: 3337 Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom
Post
by Sainath.Srinivasan » Mon Feb 21, 2005 9:25 am
Unless otherwise it is an error message returned by the call, you may have to identify the reason yourself. This is because the stages in DataStage rejects rows which differs as part of their functionality.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Feb 21, 2005 2:49 pm
Check for link variables such as LASTERR and DBMSCODE.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
xlnc
Participant
Posts: 7 Joined: Mon Feb 21, 2005 4:43 pm
Post
by xlnc » Mon Feb 21, 2005 5:53 pm
If the row is rejected from any perticular stage then you might want to debug it using a peek stage and establish a reason why , but if it is a target stage then the best way is to go with a user defined update sql and capturing the error code.
chalasaniamith
Participant
Posts: 36 Joined: Wed Feb 16, 2005 5:20 pm
Location: IL
Post
by chalasaniamith » Mon Feb 21, 2005 10:22 pm
use peek stage and find out where the row is getting rejected check with the variables,schema u can figure it out from there.
akrzy
Participant
Posts: 121 Joined: Wed Dec 08, 2004 4:46 am
Post
by akrzy » Tue Feb 22, 2005 5:34 am
how can I use DBMSCODE or LASTERR?
Sainath.Srinivasan
Participant
Posts: 3337 Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom
Post
by Sainath.Srinivasan » Tue Feb 22, 2005 5:44 am
These are values present under Link Variables -> Output. They mentioned the error value from the RDBMS stage. You need to transform this into meaningful values.
akrzy
Participant
Posts: 121 Joined: Wed Dec 08, 2004 4:46 am
Post
by akrzy » Tue Feb 22, 2005 5:47 am
I can'y find LinkVariable in the Deriviation of Transformer Stage
akrzy
Participant
Posts: 121 Joined: Wed Dec 08, 2004 4:46 am
Post
by akrzy » Tue Feb 22, 2005 6:37 am
In the Expression Editor the option "Link Variables >Constants..." is grey.
???
Sainath.Srinivasan
Participant
Posts: 3337 Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom
Post
by Sainath.Srinivasan » Tue Feb 22, 2005 7:16 am
Because it is available from Server Edition.
You can set commit size of 1 and pass another link to reject with details of error.
For more information you can search the forum.