Page 1 of 1
Sequence Generator
Posted: Mon Mar 16, 2009 6:37 am
by srai
Hi,
Can anybody tell me how to generate sequence in datastage server job?
Posted: Mon Mar 16, 2009 6:53 am
by srinivas.g
use Keymgtgetnextvalue built in function
Posted: Mon Mar 16, 2009 7:17 am
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.