Hi All,
I have a issue in getting all the values of the a single parameter ( which is a file name that is dynamically generated while looping) used inside a loop at the end of the loop in a variable.
For e.g.
Loop 1 : var1 = 'file1.sql'
Loop 2 : var1 = 'abc.sql'
Loop 3 : var1 = 'xyz.sql'
I want a variable to hold all the values of variable var1 out of the loop.
Thanks in Advance,
Arun.
Help Regarding Loop Variables inside a Sequence Job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Mon Oct 22, 2012 2:12 am
- Location: Chennai
Help Regarding Loop Variables inside a Sequence Job
Knowledge is Wealth.
Hi Arun,
If you are getting the values of a single parameter from a file then using list loop can help you.
1. Cat the file with execute command|xargs|tr -d '\n'
Eg- Output will be file1.sql abc.sql xyz.sql
2.Pass the command output to the loop using list loop.
3.Get the execute command output in a user variable activity once the loop is finished through a activity variable.
Please correct me if I am wrong.
If you are getting the values of a single parameter from a file then using list loop can help you.
1. Cat the file with execute command|xargs|tr -d '\n'
Eg- Output will be file1.sql abc.sql xyz.sql
2.Pass the command output to the loop using list loop.
3.Get the execute command output in a user variable activity once the loop is finished through a activity variable.
Please correct me if I am wrong.