Object ID - Teradata Meta Data Services

Teradata Meta Data Services Programmer Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
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.