I need an idea as how to process files in the directory file by file method using pattern after listing file names in the list and retrieving each file name in the list for process.I'm stuck at this point..Once read file names how should I proceed to put the file in the specific path and how do I come to know the file processing is completed to start with the next file? Pls direct me
So... you've put a list of filenames in a file and want to know how to leverage that file? If that's the case, then use File Pattern in the Sequential File stage and give it your filename.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Thanks..I don;t want to use the pattern method reading from seq file..In the event of failure/issues it would be difficult to trace files if I use that method. I have already used that method..But I want to know if it can be done efficiently using scripting like as each file gets processed log will show that file processes successfully.
Whatever you want it to be. When you read your file it's the line terminator character, but you can convert that you anything you like in a User Variables activity.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
thanks Ray.But your answer is not clear to me.. I meant how should I give a input to the start loop activity for a list of file names.. Should I give .list as an input? or the file pattern?
This is not the answer for your question. But it would be great if you locate 'Help' button on the start loop activity That will give you enough information
Kandy
_________________
Try and Try again…You will succeed atlast!!
I do want to provide list file names explicitly coz..Instead is there a way that I can do this coz I'm not sure about the number of files..So need to use file pattern
Why not simply use the File Pattern capability of the Sequential File stage and be done with this? Is there something in what you are doing that requires you to process each file one at a time?
-craig
"You can never have too many knives" -- Logan Nine Fingers
India2000 wrote:it would be easier track issues with files if I use this method
Why? What would be easier about it? The stage can import the current filename along with the data, if that is your concern. To me, this seems like more work for zero gain. [shrug]
-craig
"You can never have too many knives" -- Logan Nine Fingers