Search found 36 matches

by vpauls
Wed Feb 28, 2007 10:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: loop for performing jobs to different tables and files?
Replies: 10
Views: 2528

Thanks, I solved it in a "ugly" way I suppose but it seems to work. I just added a user Variable activity that performes checks and matches the correct items before continuing with the assigned jobs. The reason I think this procedure is preferable is that I need users to be able to change ...
by vpauls
Tue Feb 27, 2007 9:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: loop for performing jobs to different tables and files?
Replies: 10
Views: 2528

I simply wrote down my list in the property window for the start loop activity. Then I assigned a parameter in every job represented in my sequence. In the sequence propertie's box I then assigned the Start_loop.$Counter to my parameter.

first issue solved, but the second one remains
by vpauls
Tue Feb 27, 2007 9:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: loop for performing jobs to different tables and files?
Replies: 10
Views: 2528

further issues

Directly after solving the first issue I ran into another one. I have a list loop consisting of a list of numbers, for each of these nombers I need to define a password. The password have to be uinqe for each number in the list loop. The unique password is then supposed to be passed on as a paramete...
by vpauls
Tue Feb 27, 2007 8:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: loop for performing jobs to different tables and files?
Replies: 10
Views: 2528

Almost :-) I think I have managed to solve the problem anyway, just like you said it turned out to be quite straight forward. Just using a loop with a list loop.


chulett wrote:Again - where exactly are these 'lists' stored? In a flat file somewhere? Database? Piece of paper on your desk? :wink:
by vpauls
Tue Feb 27, 2007 8:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: loop for performing jobs to different tables and files?
Replies: 10
Views: 2528

thanks

Oh... and Welcome! :D Didn't notice this was your first post. :) thanks :) On the other topic, yes I have everything I need in every job. Then I have two different varibles, or it it is more two different lists containing numbers that are all supposed to be used once for all jobs in the sequence.
by vpauls
Tue Feb 27, 2007 5:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: loop for performing jobs to different tables and files?
Replies: 10
Views: 2528

loop for performing jobs to different tables and files?

I have a sequence consisting of nine different jobs. All jobs perform a loading of data from a database to a fil and another database. Depending on a specific variable the target file and target database are to be different. The variable has a limited amount of different values and I want to perform...