Using sequence job to read multiple files of directory

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

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

Post by ray.wurlod »

You have definitely specified comma as the delimiter in the StartLoop activity? Please check.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dh_Madhu
Premium Member
Premium Member
Posts: 65
Joined: Sat Apr 23, 2005 3:19 am
Location: Stirling, Scotland

Post by dh_Madhu »

EXECUTE_COMMAND (Uses wildcard to get files and uses the ls -m parameter ......but without a comma ----> StartLoop (this is now looping through a list but looking for a comma which does not exist !"
Now why not try the ls -1 too .....you dont have to worry about the comma's... :) .
...but for unix.
Regards,
Madhu Dharmapuri
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sounds like you are passing the entire list to the Job Activity stage parameter rather than just the 'current' filename from the list based on the loop counter $Counter - see this post for one example of many here.
-craig

"You can never have too many knives" -- Logan Nine Fingers
BIuser
Premium Member
Premium Member
Posts: 238
Joined: Thu Feb 02, 2006 4:03 am
Location: South Africa

Post by BIuser »

Thank you to everyone who has had input in assisting me to resolve my problem.

My job is working successfully now.

Thank you so much !

Kind regards,
Barbara
-------------------------
https://www.ssa.co.za
Post Reply