Design scenario for calling sequence multiple times

RK72 · Post by **RK72** » Fri Feb 22, 2013 10:21 am

I have a very basic design but am wondering if it's possible to use the start and end loop activity for this. As the title suggests i have a sequence that needs to be called several times by passing a different file name each time.

For now i simply have a master sequence that has multiple job activity stages. My question is can the same be accomplished using the loop activity stages and if so how will i pass different file names? Thanks!

ray.wurlod · Post by **ray.wurlod** » Fri Feb 22, 2013 3:51 pm

Definitely. Use a "list of things" loop. Pass it a delimited list of file pathnames. Within the loop access the activity variable StartLoop.$Counter which will contain the pathname of the file for that iteration. (StartLoop needs to be replaced with the name you used for your Start Loop activity.)

RK72 · Post by **RK72** » Tue Feb 26, 2013 5:08 pm

Sorry..... I'm unable to see your entire post. Is there anyway I can do that without the price tag? Thanks!

ray.wurlod · Post by **ray.wurlod** » Tue Feb 26, 2013 7:33 pm

You wouldn't have missed much, so I unprotected it.

RK72 · Post by **RK72** » Thu Mar 14, 2013 9:57 am

Thank you for unprotecting it and apologize for the delayed response. The "list of things" seems to work fine as the loop goes over as many items as I have.

But I seem to be unable to pass different parameters to this Job Activity. For example, every run will have a unique identifier that needs to be passed to the Job. How can I accomplish this?

Thanks in advance!

prasannakumarkk · Post by **prasannakumarkk** » Thu Mar 14, 2013 10:19 am

You mean within in the loop you have to pass more than one parameter and that too differently?
Tell number of parameters and what are those.

RK72 · Post by **RK72** » Thu Mar 14, 2013 10:30 am

Yes, that is correct. For now I have only 2 params; file name and unique identifier. So if the job reads 4 files, I'll have to pass 4 file names (which the loop handles) plus 4 different values for Identifier that will be passed to the job inside a sequence....

chulett · Post by **chulett** » Thu Mar 14, 2013 10:47 am

One way: viewtopic.php?t=127425

prasannakumarkk · Post by **prasannakumarkk** » Thu Mar 14, 2013 10:53 am

So one more question at what frequency this unique identifier can be reset.

If it is for a run:
1) You can have a user variable activity side the loop and increment it. Guess there will be more better solution than this

If it has to be unique over a period of time, you have to use a external sequencer or maintain the value in a file. increment in each run , rewrite it.

RK72 · Post by **RK72** » Thu Mar 14, 2013 3:10 pm

Thanks for the responses. I'm unsure whether I can write to a file and read from it as the params are passed via a UNIX script....

And to answer the frequency of reset Q, I'm not sure about that one either. All I know is that they have to be unique for every run and there may be thousands of run for the same job.