User Variable activity stage

[rajeevm]

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

[ray.wurlod]

Arguments to Convert() are in the wrong order. And the names of activity variables begin with the "$" character. Try something like

Code: Select all

Convert(@FM, ",", ExecCommand.$Output)

Build it with the expression editor so that you get hints about what goes where and don't mis-spell the activity name.