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
-
srinivas.nettalam
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
Post
by srinivas.nettalam »
times29 wrote: any idea what can i do to make it unique
To get unique sequence number across, the formula is
Code: Select all
[@PARTITIONNUM + (@INROWNUM-1)*@NUMPARTITIONS]+1
N.Srinivas
India.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
"a" formula (not "the" formula)
Square brackets are not supported in expressions in DataStage, though your intent is clear.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
william1111
- Participant
- Posts: 1
- Joined: Fri Feb 08, 2013 7:15 am
Post
by william1111 »
Hi,
To maintain Unique values, You should run your transformer in Sequential mode. Change Parallel to Sequential mode for only Transformer in Your Job.
Thanks,
William
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
Welcome aboard. The formula using system variables is guaranteed to generate unique numbers irrespective of the number of nodes.
You could even add a job parameter with the starting value.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
123gopal
- Participant
- Posts: 16
- Joined: Sat Feb 09, 2013 11:41 am
- Location: chennai
Post
by 123gopal »
in ds7.5 transformer can be use seconds from time(time) functions and date and time funtions are available
mgplk