Unique Key

From: Paul Bennett <bennett_at_cc.gatech.edu>
Date: 1998/03/31
Message-ID: <35214337.AF149504@cc.gatech.edu>#1/1

Can someone point me to some stored procedures that are used to generate net keys?

I have a legacy client server application where the client generates the next key by checking table that is setup like:

CODE NEXT_VALUE Some sample data would be

MODULE1      100
MODULE2      201

MODULEA 4345 The client has some functions that you pass "MODULE1" and it will lock the row, update the value to 101, then return the value to the caller.

I would like to move this to the database and have the client call a stored procedure. I need some code that is similar in the fact that it uses a "code" value in a "next sequence" table.

Thank you for your help.

• Paul

Received on Tue Mar 31 1998 - 00:00:00 CST