Concatenate files in an Execute Command stage in Sequence

jweir · Post by **jweir** » Fri Sep 10, 2010 8:57 am

Hello,

I am trying to concatenate several files into one file in a execute command stage. I am successful in concatenating them in Unix, however not in DataStage. Below is what I have written in my execute command stage:

Command: cat
Parameter: #GetPROJDEFValues.$Target_file_location#cust_mstr_r3_* >> cust_mstr_r3.txt

The parameter (#GetPROJDEFValues.$Target_file_location#) is my target file path.

I have several files that start with 'cust_mstr_r3_' and I wish to combine them all into one file called 'cust_mstr_r3.txt'

The sequence runs successfully, however it does not create my master file. Any siggestions?

anbu · Post by **anbu** » Fri Sep 10, 2010 9:00 am

Add full path to the target file cust_mstr_r3.txt

jweir · Post by **jweir** » Fri Sep 10, 2010 9:04 am

Thanks anbu!

chulett · Post by **chulett** » Fri Sep 10, 2010 9:33 am

It is getting created, just not where you are expecting. Relative pathed files end up in the job's Project directory, check there.