Is it possible to add colums in modify stage?

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

Post Reply
vasam
Participant
Posts: 30
Joined: Wed Nov 04, 2009 5:06 am

Is it possible to add colums in modify stage?

Post by vasam »

Hi All,

Is it possible add columns in modify stage? if yes ,i want to assign those column to setnull. and one more thing is it possible to give default values like (99999) for output columns whiver newly added in modify stage?


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

Post by ray.wurlod »

It is possible to add columns in the Modify stage. However, each must be derived from some input column in some way. Therefore there is no equivalent of setting to a constant or null.
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