Hi , i am trying to pass the whole sql as a parameter to a particular job.
exec_commd-->user_variable-->parallel job
Query is like below
SELECT CUSTID CUSTOMER, EMPID, CITY FROM TABLE A WHERE A.CUSTID = 123
I have used the following argument in the usser variable activity stage
Field(Trim(StartLoop.$Counter,'"'),@FM,1)
i was able to pass only SELECT CUSTID CUSTOMER to the job , could you please advice how should i write the argument in order for the job to get the whole sql.
Thanks
kumar
User Variable activity
Moderators: chulett, rschirm, roy
You must have more in the job than:
I think the loop separator is set comma as default som if you pass your query statement though the loop it will cut the query where it encounters the first comma and only pass "SELECT CUSTID CUSTOMER" to the job
...since you use the output "StartLoop.$Counter".exec_commd-->user_variable-->parallel job
I think the loop separator is set comma as default som if you pass your query statement though the loop it will cut the query where it encounters the first comma and only pass "SELECT CUSTID CUSTOMER" to the job
_________________
- Susanne
- Susanne