Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 27 Apr 2004 @ 08:29:14 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Retrieving the generated identity value
 
From:   Victor Sokovin

Jonathan,

You could develop the idea further for concurrent sessions by introducing some kind of a check out/check in mechanism. For example, define a special flag for each ID column. Every time a session requests the max value it sets the flag to, say, 1 (check out). After the session is done with its work it sets the value back to 0. Flag=0 should be a condition under which any session can ever get the actual max value. I think such a mechanism would not create any performance bottlenecks in your situation (new product IDs).

I don't think you can have any "out of the box" solution for what you are looking for, so if your consider using generated IDs in this context, some work needs to be done anyway.


Regards,

Victor



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016