Sequence number generation issue in target database

[chulett]

Which is not as simple as it sounds.

[123gopal]

Sequence numbers can be generated in Datastage server job transformer using certain fuctions like
select ... ->funtions tab->dstransform->sdk->keymgt->select given below functions
-KeyMgtGetNextVal(seq name)
-KeyMgtGetNextValConn(seq name)

Sequence numbers can be generated in Datastage parallel job transformer using certain fuctions like
-@Inrownum
-@Outrownum
if we use this function also generate the number but can't mention column name
otherwise can be use surrogate key generator stage

[prasson_ibm]

Hi Gopal,
Thanks for your reply but unfortunatly i can not use Server Jobs in my project.

If you go through this post,i am also generationg sequence number using @INROWNUM,but my question here is bit different.
Request you to please go through post properly and help me to reslove it.

[ray.wurlod]

i can not use Server Jobs in my project.

Why not?

And in any case, these functions are available in the BASIC Transformer stage (available in parallel jobs), or you could package some server job components into a server Shared Container and use that in a parallel job.

On those bases it was reasonable to introduce the key management routines.