Search found 5 matches

by mohan2312
Thu May 25, 2017 10:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing Rejected data columns in to reject file using RCP
Replies: 8
Views: 7202

Re: Capturing Rejected data columns in to reject file using

Can anyone please respond to this post. I am stuck with jobs development due to this issue. Any help is appreciated
by mohan2312
Tue May 16, 2017 11:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing Rejected data columns in to reject file using RCP
Replies: 8
Views: 7202

Try checking with Disabling RCP and Map all the columns till the Target connector,Then you can check the columns list on the oracle connector output tab for reject link. This is a generic job and I dont know the what columns will come for a table. That is the reason to go with RCP instead of mappin...
by mohan2312
Tue May 16, 2017 11:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing Rejected data columns in to reject file using RCP
Replies: 8
Views: 7202

How did you look at your reject file? I went and did view data on the reject file. Since there are only ERRORTEXT and ERRORCODE columns in the metadata so i am able to view only these two columns. I also went and checked the file in the unix path manually and the file also doesnt have other columns...
by mohan2312
Tue May 16, 2017 11:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing Rejected data columns in to reject file using RCP
Replies: 8
Views: 7202

cdp wrote:In your target Oracle Stage output/columns tabs... Is the 'Runtime column propagation' box checked ?
Yes, in the target connector Runtime Column Propagation box checked.
by mohan2312
Mon May 08, 2017 4:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing Rejected data columns in to reject file using RCP
Replies: 8
Views: 7202

Capturing Rejected data columns in to reject file using RCP

I am using generic job to extract a table and load the same table in another schema using RCP enabled in the job. The target connector ( oracle) has a reject link with ERROR CODE and ERROR TEXT columns selected. When I ran the job and there were rejects, I could only see ERROR CODE and ERROR TEXT in...