File name with value from column

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
Marcus426
Participant
Posts: 33
Joined: Wed Sep 09, 2009 1:37 am

File name with value from column

Post by Marcus426 »

Hi all,


Can anyone tell me how to create the target sequential file name based on the column value.

column
ABC
ABC
ABC
ABC


file name ABC.txt

All the values in the column are constant.


THanks!
Marcus Herbst
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Only in a separate job (or routine or command) that identifies the name and passes it to the main job as a parameter value.
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
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Right, the name is set when the job starts so it must provided at that time. You'll either need to pass it in as a job parameter or arrange for the file to be renamed post-job.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply