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
dodda
Premium Member
Posts: 244 Joined: Tue May 29, 2007 11:31 am
Post
by dodda » Mon May 04, 2009 3:16 pm
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
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon May 04, 2009 3:21 pm
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
Posts: 533 Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago
Post
by nagarjuna » Mon May 04, 2009 8:34 pm
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
Posts: 244 Joined: Tue May 29, 2007 11:31 am
Post
by dodda » Tue May 05, 2009 9:05 am
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
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue May 05, 2009 11:10 am
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 » Thu May 07, 2009 10:49 pm
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?
else mate...dodda... us peak stage and tune it as per your choice
Thanks,
DS_Learner
John Smith
Charter Member
Posts: 193 Joined: Tue Sep 05, 2006 8:01 pm
Location: Australia
Post
by John Smith » Fri May 08, 2009 12:42 am
In your input seq file stage you can add the option for File Name Column.