problem regarding job compilation and running

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

ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

priyadarshikunal already showed you how to remove the warnings.

RCP is usually set on the Output properties, Columns tab.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rahul8055
Participant
Posts: 95
Joined: Wed Jun 23, 2010 7:41 pm

Post by rahul8055 »

ray.wurlod wrote:priyadarshikunal already showed you how to remove the warnings.

RCP is usually set on the Output properties, Columns tab. ...

what should I do for the RCP do i need to change it in the stages?

and the other warning is the sort stage....could you tell me what can i do....the
warning is in my previous posts..

thanks,
Rahul
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

priyadarshikunal already showed you how to remove the warnings.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

datastage by default inserts a sort check before remove duplicate stage and that default operator expects the data to be sorted in ascending order. The time you change the sort order to ascending the warning will disappear but you need to be careful as changing the sort order may lead to incorrect results.

so first check the requirements before you do anything.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
rahul8055
Participant
Posts: 95
Joined: Wed Jun 23, 2010 7:41 pm

Post by rahul8055 »

priyadarshikunal wrote:datastage by default inserts a sort check before remove duplicate stage and that default operator expects the data to be sorted in ascending order. The time you change the sort order to ascending the warning will disappear but you need to be careful as changing the sort order may lead to incorrect results.

so first check the requirements before you do anything.

Thank you kunal,
I got rid of some warnings due to the ascending order but I get an extra column in my output is there any way to get rid of it,

and My other warning is of RCP as you said how do I get rid of it ...?

thanks,
rahul
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Go back, read all the advice carefully. Everything you need to do is already in this thread.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply