Sequence Stage problem

karthi_gana · Post by **karthi_gana** » Tue Nov 15, 2011 1:32 am

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

sathya_anjan · Post by **sathya_anjan** » Tue Nov 15, 2011 3:36 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Nov 15, 2011 2:30 pm

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

karthi_gana · Post by **karthi_gana** » Fri Nov 18, 2011 4:22 am

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?

pandeesh · Post by **pandeesh** » Fri Nov 18, 2011 5:23 am

Use convert() to convert @FM to comma.

Code: Select all

Convert(@FM,",",column)