17.10 - Format of the Mapping File - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

The format of the mapping file is multiple lines, with each line terminated by a linefeed character. This may be problematic for editors that expect carriage-return or carriage-return followed by linefeed to terminate a line.

Linefeed termination is the UNIX convention. Carriage-return linefeed is the Windows convention.

Each translation table starts with a #BEGINMAP line and ends with an #ENDMAP line. Other than those two commands, the # indicates the start of a comment that continues to the end of line. Blank lines are ignored.

The #BEGINMAP and #ENDMAP statements also include the name of the map being defined.

For an example, see Example Mapping File.