Surrogate key gen NEXT value

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
ds_is_fun
Premium Member
Premium Member
Posts: 194
Joined: Fri Jan 07, 2005 12:00 pm

Surrogate key gen NEXT value

Post by ds_is_fun »

Im currently using generate key from last highest value in a SK generator stage. This is not producing a NEXTVAL for me.
What is a way to obtain next value froma SK generator stage?
Thanks
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

:? If I'm following... add 1 to your "last highest value" before you pass it to the job / stage.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”