Page 2 of 2
Posted: Sun Feb 10, 2013 9:39 am
by chulett
Which is not as simple as it sounds.
Posted: Sun Feb 10, 2013 10:37 am
by 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
Posted: Tue Feb 12, 2013 8:12 am
by 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.
Posted: Tue Feb 12, 2013 3:56 pm
by ray.wurlod
prasson_ibm wrote: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.