Dynamically naming a file based on the value in column1

vamsi_4a6 · Post by **vamsi_4a6** » Thu Sep 10, 2015 5:58 am

1)Get the distinct values in column1 using unix or datastage.Write them into some text file.

2)use looping in jobsequence to iterate for each value present in text file.withinlopping pass the value as parameter to jobactivity

chulett · Post by **chulett** » Thu Sep 10, 2015 7:07 am

I seem to recall this being added as a feature in one of the later versions of DataStage... can anyone confirm / deny?

qt_ky · Post by **qt_ky** » Thu Sep 10, 2015 7:34 am

Good memory, Craig!

Please see my post on this topic.

JPalatianos · Post by **JPalatianos** » Thu Sep 10, 2015 8:13 am

Thank You everyone for your suggestions! When using the "Generate Multiple file" option using a key do you know the default directory where the output files get written too?

qt_ky · Post by **qt_ky** » Thu Sep 10, 2015 8:26 am

As with any use of the Sequential File stage, it will place the file(s) in whatever path you specify. We normally prefix every file name with a parameter which holds the value for the path. If you don't specify a path, then the file(s) will be written into the DataStage project path, mixed in with all the system files for your job designs, etc. The default is not usually the best place for your data files.

JPalatianos · Post by **JPalatianos** » Thu Sep 10, 2015 8:28 am

Perfect..This solution works perfectly!

Thank You All!!