Concatenate without transformer

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
Pavan_Yelugula
Premium Member
Premium Member
Posts: 133
Joined: Tue Nov 23, 2004 11:24 pm
Location: India

Concatenate without transformer

Post by Pavan_Yelugula »

Hi All
Is there any other stage i can use for concatenating a set of coloumns other than Transfomer???
Can a Modify stage be used. If Yes can anyone kindly direct me how i achieve it with the syntax. Irrespective of what i try in the Modify it fails in the run time....

Any help will be really Appreciated

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

Post by ray.wurlod »

Modify stage can not, as a general rule, perform operations that take two inputs. Therefore concatenation is not an operation that a Modify stage can perform.

Transformer is the correct stage for the task.

You could create your own (Build) stage, you could use an External Filter stage, but Transformer should be your choice.
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