@ITERATION variable in Transformer stage

anand_chal · Post by **anand_chal** » Mon Feb 11, 2013 11:52 pm

Hi I am trying to make use of looping in transformer stage in my job design. But i am not able to view the @ITERATION variable in my system variable list. I tried by adding the entry in DSParams file for it. But it didnt helped me. If any body came across the same situation plz help.

Thanks in advance

prasson_ibm · Post by **prasson_ibm** » Tue Feb 12, 2013 12:21 am

Hi,
Which version of datastage you are using..??

prasson_ibm · Post by **prasson_ibm** » Tue Feb 12, 2013 8:06 am

Transformer Iteration is only included in Datastage 8.5 and higher versions.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 12, 2013 3:54 pm

I would assume that the statement "trying to make use of looping" suggests very strongly that version 8.5 or higher is involved.

@ITERATION will only appear in the derivation of the Loop condition itself or loop variables. It is not available for output link constraints or in any other kind of expression in the Transformer stage.