Merge stage in server jobs

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vinsashi
Participant
Posts: 150
Joined: Mon Aug 20, 2007 4:52 am
Location: singapore

Merge stage in server jobs

Post by vinsashi »

Hi,
merging two files ,should i need to specify all columns of files in merge stage.if not specify its showing error after running.

example
file1:
c1|c2|c3|c4|c5|c6
file2:
d1|d2|d3|d4

outputfile:
c1|c2|c3|c4|d1|d2|d3|d4


at merge stage level for first file i didnt specified c5 and c6 at column definition level.if i run job the job got aborting.

at merge level in server jobs should we need to keep all columns if not necessary to next stage also.

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

Post by ray.wurlod »

Any time you're working with a sequential file - and this includes the Merge stage - you must mention the entire structure. The term "sequential" implies that you have to read past every byte in the file to get to the next one.
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