| Author |
Message |
anand_chal
Group memberships:
Premium Members
Joined: 28 May 2011
Posts: 8
Points: 107
|
|
| DataStage® Release: 8x |
| Job Type: Parallel |
| OS: Unix |
|
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
Group memberships:
Premium Members
Joined: 11 Oct 2007
Posts: 536
Location: Bangalore
Points: 4830
|
|
|
|
|
prasson_ibm
Group memberships:
Premium Members
Joined: 11 Oct 2007
Posts: 536
Location: Bangalore
Points: 4830
|
|
|
|
|
ray.wurlod
Participant
Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group
Joined: 23 Oct 2002
Posts: 54601
Location: Sydney, Australia
Points: 296091
|
|
|
|
|
|
|
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 conditio ...
|
_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold. |
|
|
|
|
pnpmarques
Participant
Joined: 15 Jun 2005
Posts: 36
Points: 288
|
|
|
|
|
|
Same problem here. I don't know why @ITERATION does not appear, but you can apply same logic without that system variable, try this:
Loop While: LoopVar<=DCOUNT(Input_column,';')
Loop Variable to get string: Field(Input_column,';', LoopVar)
Loop Variable LoopVar: LoopVar+1
|
|
|
|
|
|
|
|
