17.20 - 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.20
Published
June 2022
Last Update
2022-06-24
Content Type
Configuration
User Guide
Publication ID
B035-1125-172K
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.