Sequence number generation issue in target database
Moderators: chulett, rschirm, roy
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
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
mgplk
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
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.
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.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why not?prasson_ibm wrote:i can not use Server Jobs in my project.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.