loop concept in Transfomer stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sainath
Premium Member
Premium Member
Posts: 138
Joined: Fri Nov 19, 2004 3:57 pm

loop concept in Transfomer stage

Post by sainath »

hi

I have sample data in a column which i have to parse the code in each seperate row,

;abc;def;ghi;


when i tried to use while condition

@ITERATION <=Dcount (which is count of ';' delimiters) Datastage

is saying it is not valid...the datatype for Dcount is integer ...

please share your thought

thks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

DCOUNT is a reserved word (it's the name of a function). Use a different name for the stage variable.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply