Sequence Generator

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
srai
Participant
Posts: 101
Joined: Wed Feb 09, 2005 10:50 pm

Sequence Generator

Post by srai »

Hi,

Can anybody tell me how to generate sequence in datastage server job?
Top
srinivas.g
Participant
Posts: 251
Joined: Mon Jun 09, 2008 5:52 am

Post by srinivas.g »

use Keymgtgetnextvalue built in function
Srinu Gadipudi
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Or the ROWNUM system variables - @INROWNUM or @OUTROWNUM. Or a database sequence. The answer can depend on if you need to worry about concurrency or not.
-craig

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

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”