MapsV[X] - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

Category: Schema

Database: DBC

View Column Data Type Format Comment
MapName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns name of the map.
MapSlot SMALLINT NOT NULL ---,--9 Returns the physical number of the map.
MapKind CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Returns MapKind C for a contiguous map S for a sparse map.
SystemDefined CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Returns Y if the map is created during a system initialization (sysinit) or reconfiguration. It is N for a map created by CREATE MAP.
SystemDefault CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Returns Y if the map is the system-default map, N otherwise.
ParentMapName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns name of the parent contiguous map that a sparse map is based on. It is null for a contiguous map.
NumberOfAMPs SMALLINT NOT NULL ---,--9 Returns the number of AMPs in a contiguous or sparse map.
ContiguousStartAmp SMALLINT NOT NULL ---,--9 Returns the lowest AMP number in a contiguous map or, for a sparse map, in the parent contiguous map.
ContiguousEndAmp SMALLINT NOT NULL ---,--9 Returns the highest AMP number in a contiguous map or for a sparse map, in the parent contiguous map.
CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns username of the user that created the map if the map is a sparse map. This is null for a system-defined map.
ZoneName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the secure zone name.
CreateTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the date and time the map was created.
CommentString VARCHAR(255) UNICODE NOT CASESPECIFIC X(255) Returns optional comment on the created map.
FallbackKind CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Returns D for dedicated fallback or L for legacy fallback.
TotalNumberOfAMPs SMALLINT NOT NULL ---,--9 Returns the total number of AMPs, both primary and fallback.