User Generated OID

How can I define an user genarated OID?

For example in IBM's DB2 I have an type to be referenced as (for example VARCHAR) and then by using the sentece REF IS OID USER GENERATED when I define an table of the type, I can refer to an object whith the value of the OID which is VARCHAR.
panalexAsked:
Who is Participating?
 
schwertnerConnect With a Mentor Commented:
Purpose

SYS_GUID generates and returns a globally unique identifier (RAW value) made up of
16 bytes. On most platforms, the generated identifier consists of a host identifier, a
process or thread identifier of the process or thread invoking the function, and a
nonrepeating value (sequence of bytes) for that process or thread.
Examples
The following example adds a column to the sample table hr.locations, inserts
unique identifiers into each row, and returns the 32-character hexadecimal
representation of the 16-byte RAW value of the global unique identifier:
ALTER TABLE locations ADD (uid_col RAW(32));
UPDATE locations SET uid_col = SYS_GUID();
SELECT location_id, uid_col FROM locations;
LOCATION_ID UID_COL
----------- ----------------------------------------
1000 7CD5B7769DF75CEFE034080020825436
1100 7CD5B7769DF85CEFE034080020825436
1200 7CD5B7769DF95CEFE034080020825436
1300 7CD5B7769DFA5CEFE034080020825436
. . .
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.