How to use OID in the program? (DBMR1974; version：DBMaker 4.2 in Linux)
The OID is a special data type. Although it is possible to use an OID in a query to select data from a table and then use the OIDs to update the table data, this is not common practice when using the SQL language. OIDs are usually used in the internal programming interface.
So please not directly use OID in program, otherwise, it may be cause some strange codes sometimes.
In fact, they only need to get object name related with this OID.
For example:
select USER_NAME, TABLE_NAME, SYSLOCK.LK_GRAN, SYSLOCK.HOLD_LK_CONNECTION,
SYSLOCK.LK_CURRENT_MODE from SYSLOCK,SYSTEM.SYSTABLE,SYSUSER where
HOLD_LK_CONNECTION = CONNECTION_ID and LK_OBJECT_ID = TABLE_OID and
TABLE_OWNER != 'SYSTEM';