DSXchange

how the above loop process will be executed by datastage internally?

Karthik,

If you provide the File name from the Command Output it would be the list of all the files from the ls -m command.

The reason you are using Start List Loop option with a Comma Delimeter is feed individual file names into the Sequential stage File name.

You should use the Output from the Counter of Start Loop rather than output from Execute Command.

The difference is not in the Command but using the right output from the right stage, which is from Start Loop.

Thanks

Sathya

Why not convert the @FM characters to commas? Then you would have a comma-delimited string that could be processed by the StartLoop activity.

ray.wurlod wrote:Why not convert the @FM characters to commas? Then you would have a comma-delimited string that could be processed by the StartLoop activity.

Could you explain it more pls?

Use convert() to convert @FM to comma.