SEQUENCE NUMBER GENERATION FUNCTION

babuselvan · Post by **babuselvan** » Tue Nov 10, 2009 4:16 am

We want to generate sequence for a set of records. What is the available function to generate a sequence number for a set of record in the datastage?

mgendy · Post by **mgendy** » Tue Nov 10, 2009 4:22 am

You Can Use Surrogate Key Generator , either in sequential mode , or in parallel mode using round robin partitioning method

babuselvan · Post by **babuselvan** » Tue Nov 10, 2009 4:25 am

Can we have that surrogate key genertor function in server job mode?

mgendy · Post by **mgendy** » Tue Nov 10, 2009 4:42 am

babuselvan wrote:Can we have that surrogate key genertor function in server job mode?

no , you can't use this stage in server jobs

bkumar103 · Post by **bkumar103** » Tue Nov 10, 2009 5:18 am

you can use KeyMgtGetNextValue function

chulett · Post by **chulett** » Tue Nov 10, 2009 6:37 am

Or the @INROWNUM / @OUTROWNUM system variables. Or sequence objects in your database. Or...

DSXchange