OID

The OID (object identifier) data type is a special data type that provides a unique ID for each object (record, BLOB) stored in a database. It is a structured data type that has a precision of 10 and a scale of 0, and occupies 8 bytes of storage. DBMaker automatically generates and inserts an OID with each record. Since the OID is internally managed and maintained by DBMaker, you cannot use the OID data type directly.
The value generated for an OID is related to the storage location of objects in the database. This means that two OIDs that are generated consecutively may not necessarily be sequential.

The OID values act as a hidden pseudo-column in tables, and will not appear in queries such as SELECT * FROM Customers. However, you can explicitly select the OID column by using 'OID' as a column name in a query.

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, and not directly in the interactive dmSQL environments.

< LONG VARCHAR | Contents | SMALLINT >