Hi ,
I wanted to pass the output from the Exec command output in datastage to user variable actity which holds the list of the files separated by comma delimiter and pass one file to job where i have the loop in place . This is the output from exec command output
abc.txt
xyz.txt
123.txt
These are the files from the exec command and i did below in user variable actvity variable convert(exec_command.output,@FM,',') but nothing is passing to the job for the filename
Please help me with this. I really appreciate it.
REgards
Raj
User Variable activity stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Arguments to Convert() are in the wrong order. And the names of activity variables begin with the "$" character. Try something like
Build it with the expression editor so that you get hints about what goes where and don't mis-spell the activity name.
Code: Select all
Convert(@FM, ",", ExecCommand.$Output)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.