reading multiple files

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
dodda
Premium Member
Premium Member
Posts: 244
Joined: Tue May 29, 2007 11:31 am

reading multiple files

Post by dodda »

Hello

I am reading multiple files from sequential file stage by using the Read Method: File patern. My job is Seqfilestage--transformer--seqfilestage.

I have 3 files in the input directory with file name pattern similar (*.dat). The job is running fine and i am getting the output which has the contents of the 3 inpiut files. Is there a way that we can track each file name??

thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

There is, and a search for "file pattern" turned up a number of conversations, including this one which looks like it should help.
-craig

"You can never have too many knives" -- Logan Nine Fingers
nagarjuna
Premium Member
Premium Member
Posts: 533
Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago

Post by nagarjuna »

Within the sequential file use the option file pattern and also filename ..I think it will give output along with the filename .
Nag
dodda
Premium Member
Premium Member
Posts: 244
Joined: Tue May 29, 2007 11:31 am

Post by dodda »

chulett wrote:There is, and a search for "file pattern" turned up a number of conversations, including this one which looks like it should help.

Hi

Thanks for the reply. I want to track the filename of the each file being processed in datastage director.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

OK, go fo it. If you have a question, ask it.
-craig

"You can never have too many knives" -- Logan Nine Fingers
datastage_learner
Participant
Posts: 15
Joined: Thu May 07, 2009 9:50 pm

Post by datastage_learner »

Thanks for the reply. I want to track the filename of the each file being processed in datastage director.
mate dodda...whats the issue in tracking the filenames in director? doesn't director gives you a running log of everything? :roll:

else mate...dodda... us peak stage and tune it as per your choice :wink:
Thanks,
DS_Learner
John Smith
Charter Member
Charter Member
Posts: 193
Joined: Tue Sep 05, 2006 8:01 pm
Location: Australia

Post by John Smith »

In your input seq file stage you can add the option for File Name Column.
Post Reply