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

Group memberships:
Premium Members

Joined: 07 May 2014
Posts: 16

Points: 116

Post Posted: Fri Jun 26, 2015 9:40 am Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
I am developing a new job to an existing target table. I decided to initialize the seq with max+1 value to skey file and do an update/insert into the table, so created job to load the data to the target table, whenver there is no lookup found i generate the SKey from the utility, data is generated correctly. but i see the Skey generation is generating numbers which are less than the max
+1 value which i set in intialization stage. please advice the workaround.

Premium Poster

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16318
Location: Germany
Points: 92566

Post Posted: Mon Jun 29, 2015 1:58 am Reply with quote    Back to top    

The surrogate key generator will always generate numbers that are higher than the previous call or the initial value setting. If this is not the case, then check your initial value setting and perhaps that did not work as you expected.
Try running your sequence or job that sets the surrogate key minimum. Then write a dummy job which gets the next value and writes it to a peek or a flat file and check that value.


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