Negative Surrogate Keys using Surrogate Key Generator

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
datastagenewbie
Participant
Posts: 64
Joined: Tue Sep 23, 2008 9:54 am

Negative Surrogate Keys using Surrogate Key Generator

Post by datastagenewbie »

Is there a way to generate negative surrogate keys in Datastage?
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Generated keys are unsigned 64-bit integers. I would think you'd just need to multiply each by -1 post generation to get what you want.
-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)”