LoadTablesInfoV[X] - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
prb1610499325399.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.