LOCALTABLEATOMFIELDS System Table Description

Description

A pseudo table, similar to GLOBALATOMS, except generated to show only atoms for fields, and only those atoms local to the TE to which the client is connected. (See GLOBALATOMS System Table Description.)

Client applications should never contain code that accesses SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.

Fields

Like SYSTEM.GLOBALATOMS, most fields in LOCALTABLEATOMFIELDS are not of much interest to the user. Here are a few exceptions.

Field Type Description

SCHEMA

string

The SQL schema in which the database object for the atom resides.

TABLENAME

string

The name of the table associated with the atom.

OBJECTID

integer

A unique ID identifying the database object.

TABLECATALOGID

integer

The database catalog ID for the table.

FIELD

string

The name of the field in the table.

LENGTH

integer

Length associated with the data type - this is the precision assigned to a CHAR or BINARY type or the size in bytes of the type

PRECISION

integer

The precision specified for a fixed precision numeric, CHAR or BINARY type; the max precision possible for other numeric types

SCALE

integer

The scale specified for a fixed precision numeric type

FIELDID

integer

Index of the field, that is, the column number counting left to right.

LASTVALIDFORMATID

integer

As a table has fields added or removed, its format ID increments. If LASTVALIDFORMATID is 0, it means the field is valid. If it is non-zero, it is the last table format ID for which is valid. So if a field is removed on a table with format ID 5, then LASTVALIDFORMATID will be 5

Indexes

None