DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
deesh
Participant



Joined: 08 Oct 2007
Posts: 177

Points: 1763

Post Posted: Wed Apr 19, 2017 11:40 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi, i am getting multiple files with the common structure, but my senior saying need to use the loop activity in sequence jobs and solve the issue.

Please let me know how to resolve by using start and end loop in job sequencer
danddmrs



Group memberships:
Premium Members

Joined: 20 Apr 2007
Posts: 86

Points: 895

Post Posted: Wed Apr 19, 2017 12:47 pm Reply with quote    Back to top    

DIRectory listing of the files
Flatten the list into a single comma delimited record of filenames
Read the file with the single record of filenames with a User Variable stage
Pass the uvParameter to the Start Loop (List Loop, Comma Delimited)
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 41792
Location: Denver, CO
Points: 214379

Post Posted: Wed Apr 19, 2017 3:41 pm Reply with quote    Back to top    

To kill the first two birds with one stone, doing a "ls -m" should get you your list of files directly in a comma delimited list.

_________________
-craig

The black queen chants the funeral march, the cracked brass bells will ring
To summon back the fire witch to the court of the crimson king
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours