FIle Patten issue

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
vinsashi
Participant
Posts: 150
Joined: Mon Aug 20, 2007 4:52 am
Location: singapore

FIle Patten issue

Post by vinsashi »

Hi,
In source folder i have filenames like this
FM PRINTVALUE REPORT 022211.txt
FM PRINTVALUE REPORT 022311.txt
FM PRINTVALUE REPORT 022411.txt

in seq file i mentioned with FM*.txt and read method changed to FILEPATTERN.
and extracting filename with 'FILE NAME OPTION' in seqfile.but in view data it showing FM*.txt its not getting total file name.

Please help on this
Thanks in Adavance
V...
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: FIle Patten issue

Post by SURA »

What error you are getting?

try it like *.txt

DS User
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I think you've encountered a bug. The File Name column works properly in some versions, not in others. Without knowing your exact version it's hard to say. Involve your official support provider.
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 »

Try adding and setting $APT_IMPORT_PATTERN_USES_FILESET=True in your job.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Devendrudu
Participant
Posts: 31
Joined: Tue May 24, 2011 12:16 am

Re: FIle Patten issue

Post by Devendrudu »

Hi,

yes i faced same problem. but i solved with what explained by sura i got correct answer. u can also try that one.

*.txt
Devendra,Bangalore,India
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

U didn't ask the question.

The second person personal pronoun in English is spelled "you".

U is one of our posters.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply