Sequence no column in transform stage
Moderators: chulett, rschirm, roy
Sequence no column in transform stage
how to create a sequence value for a column in transform stage?
Depends on what you need it for and what it needs to start from. Simplest way is the @IN/OUTROWNUM system variables. There's also the KeyMgmt routines in the sdk branch. The former starts at 1 but can be given an offset that you increment by them, the latter keeps track per 'object' tracked and each call gets you the next value.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers