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
@ITERATION variable in Transformer stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 8
- Joined: Sat May 28, 2011 7:51 am
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
Which version of datastage you are using..??
Which version of datastage you are using..??
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Transformer Iteration is only included in Datastage 8.5 and higher versions.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
@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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.