17.00 - LoadTablesInfoV[X] - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Category: Operations

Database: DBC

View Column Data Type Format Comment
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) TableName is the name of the LDI table in a concurrent load operation.
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) DatabaseName is the database name to which the LDI table in concurrent load operation belongs to.
LoadQueryBand VARCHAR(256) UNICODE NOT CASESPECIFIC NOT NULL X(256) LoadQueryBand is the Query_Band value of the concurrent load operation.
SingleSession CHAR(1) LATIN UPPERCASE NOT NULL X(1) SingleSession specifies if the concurrent load operation is performed by a single session or performed in multiple sessions.
ControlSessNum INTEGER NOT NULL --,---,---,--9 ControlSessNum is the session number of the session that issued BEGIN ISOLATED LOADING.
ControlHostNum SMALLINT NOT NULL ---,--9 ControlHostNum is the logical host ID of the session that issued BEGIN ISOLATED LOADING.
StartTimeStamp TIMESTAMP(6) WITH TIME ZONE NOT NULL YYYY-MM-DDBHH:MI:SS.S(6)Z StartTimeStamp is the timestamp value at the time BEGIN ISOLATED LOADING is processed.