Creates a named empty map list. The list of maps is a parameter of AnalyzeSP.
This procedure works in conjunction with AddMapListEntrySP. CreateMapListSP is called once to create an empty list, and then AddMapListEntrySP is called repeatedly to add individual maps to that list.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Syntax
CALL [TDMaps.] CreateMapListSP ( 'MapListName', ['DictionaryDatabase',] :MapListID ) [;]
Syntax Elements
- TDMaps.
- The name of the database.
- MapListName
- Name of the map list.
- DictionaryDatabase
- The name of the database where the data dictionary tables, such as TVM, reside.
- MapListID
- An output parameter that is the system-assigned numeric identifier for the list.