Happy Day.

Does anybody know what kind of Generator/Sequence functionality exists in 
DB2?  I'm looking for a way to generate unique integer IDs on the fly 
>outside of a transaction<.

In the past, when a native generator wasn't available, I've used the usual 
routine of having a table with the next available ID and incrementing it 
along the way, but there are always multi-user issues.  It's easy enough to 
avoid giving the same ID to two users, but it means transactions have to be 
extremely short and rollbacks become an issue.  Worse, when one of the 
users goes down mid-transaction things come to a halt.

Obviously native generators (or "sequences" in Oraclese) are vastly 
superior.  I've looked through the DB2 help and see nothing that looks like 
a generator (GENERATE_UNIQUE is a 13-byte string, which will definitely NOT 
serve my purposes)

Am I blind?

Cheers.
                        BJ...

---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz

Reply via email to