16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

User, Database, or Profile DEFAULT MAP OVERRIDE ON ERROR Option

If the map you specify does not exist, has not been granted to you, is not in the same secure zone, or the map is otherwise unavailable to you, a message indicates that the default map is being used instead of the map you specified. This is the default behavior if DEFAULT MAP OVERRIDE ON ERROR option is not specified for the user, database or profile. An error occurs only if DEFAULT MAP OVERRIDE NOT ON ERROR option is specified for the user, database, or profile.

See the CREATE USER DEFAULT MAP option, CREATE DATABASE DEFAULT MAP option, or CREATE PROFILE DEFAULT MAP option.

Map Used by the Function (Table Form)

The map is one of the following as listed in order of precedence:
  • Map, if specified by the EXECUTE MAP option in the FROM clause of the SELECT statement that executes the table operator. For more information, see Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .
  • Map, if specified by the EXECUTE MAP option as part of the CREATE FUNCTION statement.
  • User’s default contiguous map.

Secure Zones and Sparse Maps

For a sparse map, you must be in the same secure zone as the sparse map.