Object ID - Teradata Meta Data Services

Teradata Meta Data Services Programmer Guide

Teradata Meta Data Services
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Object ID

Each object (instance of a class) is given a unique internal identifier by MDS. When data versioning is enabled for a class, each version of an object in the class will have a separate, unique internal identifier. This ID is a long integer and is often abbreviated as a LOID. An object or a specific version of an object can be retrieved by specifying the LOID associated with the object or version.

Object IDs are 32-bit 2's-complement signed integers in Teradata, which means their range is -(2^31) ... (2^31 - 1). The order in which object IDs are used is:

          1, 2, 3, ... 2,147,483,647, -2,147,483,648, ..., -3, -2, -1

When you get to -1, you run out of object IDs and MDS returns the META_E_NO_UNUSED_LOIDS (0x80007018) error code if someone attempts to write a new object. There are 4,294,967,295 (4.3 billion) legal object IDs and 0, the null object ID.

To update an existing object, the Object ID of a version of the object must be specified.