How to get the folder name used in the folder stage into the

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
abhishekmuradia
Participant
Posts: 6
Joined: Tue May 23, 2006 10:25 pm
Location: Bangalore

How to get the folder name used in the folder stage into the

Post by abhishekmuradia »

I need help in knowing how to get the filename we are using in the folder stage for the use in the routine
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

The safest way is to make it a parameter. Otherwise the SQL to find these filenames has been posted. It should have CSeqInput and CSeqOutput so search for that.
Mamu Kim
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Which 'filename'? The first column contains the name of the file(s) read. And the name of the folder itself should be a parameter.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Sorry, I misread. I thought you wanted a filename in a sequential file stage. You are going to have to hack a solution. Like the one I have for sequential file stages.
Mamu Kim
Post Reply