Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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


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.



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