How to Read multile .csv files in Sequential stage
Moderators: chulett, rschirm, roy
How to Read multile .csv files in Sequential stage
I have files in a folder in this format:
20110701.csv
20110702.csv
.....
20110715.csv
In the sequential file stage I have
\\srcfolder\201107*.csv
But it wont work.
It works if I give a specfic file name:
\\srcfolder\20110701.csv
Any help appreciated ....
20110701.csv
20110702.csv
.....
20110715.csv
In the sequential file stage I have
\\srcfolder\201107*.csv
But it wont work.
It works if I give a specfic file name:
\\srcfolder\20110701.csv
Any help appreciated ....
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 7
- Joined: Fri Jul 08, 2011 8:32 am
- Location: AUS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: NEW TO DATASTAGE
VVVRAVINDRA999 wrote:change the forward slash to backward slash and give a try
![Confused :?](./images/smilies/icon_confused.gif)
What forward slash?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Inside the Sequential file stage I have
Source - \\ladiappd01\etl_src_files\EDW\Work_Folder\201107*.csv
Read Method - File pattern
In the source folder I have
20110701.csv
20110702.csv
....
20110719.csv
Can DataStage get all the files and run it or I need to manuall add the next date (\Work_Folder\20110701.csv)
& run it 19 times ?
Source - \\ladiappd01\etl_src_files\EDW\Work_Folder\201107*.csv
Read Method - File pattern
In the source folder I have
20110701.csv
20110702.csv
....
20110719.csv
Can DataStage get all the files and run it or I need to manuall add the next date (\Work_Folder\20110701.csv)
& run it 19 times ?
-
- Participant
- Posts: 30
- Joined: Sat Dec 19, 2009 5:19 am
- Location: Manchester, UK
While 201107* may work in UNIX, it won't match files in Windows without specifying an extension as well - meaning 201107*.* would be what you should try. I don't think it will help but can't hurt to try.
Now, I'm curious - why the UNC path? Are you looking for files on a remote server? I wonder if that is part of the issue...
Now, I'm curious - why the UNC path? Are you looking for files on a remote server? I wonder if that is part of the issue...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 30
- Joined: Sat Dec 19, 2009 5:19 am
- Location: Manchester, UK