how to generate surrogete key in server jobs?

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
karthikgk0705
Premium Member
Premium Member
Posts: 45
Joined: Tue Aug 29, 2006 2:59 am
Location: Bangalore

how to generate surrogete key in server jobs?

Post by karthikgk0705 »

Hi,
How to generate surrogate key in server jobs?which functions shd I use?

Thanks.
rasi
Participant
Posts: 464
Joined: Fri Oct 25, 2002 1:33 am
Location: Australia, Sydney

Post by rasi »

Moderator

Duplicate post to be removed
Regards
Siva

Listening to the Learned

"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
boppanakrishna
Participant
Posts: 106
Joined: Thu Jul 27, 2006 10:05 pm
Location: Mumbai

Generating the surrogate key in Server Jobs

Post by boppanakrishna »

hi ,
you can try using the "Keymgt " function to generate the surrogate key and try to change the attribute if you require the key to be startted from begining after some loading is happened ....if any pbm occurs reply back...

Thanks&Regards,
Boppana Ramakrishna
Xpert
Premium Member
Premium Member
Posts: 85
Joined: Wed Mar 01, 2006 7:17 am

Re: Generating the surrogate key in Server Jobs

Post by Xpert »

boppanakrishna wrote:hi ,
you can try using the "Keymgt " function to generate the surrogate key and try to change the attribute if you require the key to be startted from begining after some loading is happened ....if any pbm occurs reply back...

Thanks&Regards,
Boppana Ramakrishna

Hi,

U can use KeymgtGetNextVal Routine or ur logic in stage variables.
With regards,
Xpert
Post Reply