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
Inquisitive
Charter Member
Posts: 88 Joined: Tue Jan 13, 2004 3:07 pm
Post
by Inquisitive » Mon Nov 27, 2006 5:27 pm
Hi All,
Hope you are all having nice time in Holiday season.
Can you please let me know how can I concatenate 2 filesin Server Ver on Windows Ver.
I have a requirement to read mutiple files which have same metadata and process them before loading into Target DB.
Note: Those files are generated by an earlier job, so it is OK if I can write DOS script which can concatenate those 2 files as after job routine or Script.
Thanks
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Nov 27, 2006 5:49 pm
Using the type command and redirection or copy with wildcards or the append (+) operator.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Nov 27, 2006 5:53 pm
Execute the type or copy command as the Filter command in a Sequential File stage; the output link from the stage is fed from stdout of the command.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Nov 27, 2006 6:29 pm
I would have suggested that but have run into problems trying to use wildcarded cat commands in the Filter. Perhaps it works mo betta on Windows.
-craig
"You can never have too many knives" -- Logan Nine Fingers