DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
satheesh_color
Participant



Joined: 16 Jun 2005
Posts: 177

Points: 2082

Post Posted: Fri Jun 22, 2018 6:34 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi Team,


We have a requirement, we were generating seq.nextval key through DB insert statements. Is there any way can we capture the same key value with the same job.


kindly let me know your thoughts on the same.



Regards,
S.R
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54366
Location: Sydney, Australia
Points: 294898

Post Posted: Sun Jun 24, 2018 11:45 pm Reply with quote    Back to top    

Yes, you can use the Surrogate Key Generator stage. One of its methods of operation is to retrieve the next value from a database sequence. It can be made more efficient by retrieving a bloc ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours