SHOW ERRORMAP
Purpose
Displays the contents of the tables that map error codes to severity levels.
Syntax
Usage Notes
Use the SHOW ERRORMAP command to display the return code associated with a specific error. See “ERRORLEVEL” on page 149 for more information.
Data is returned in two sets:
System Error Mapping contains information about all of the default return codes supported by BTEQ and their return values. If the severity level of any of these errors is overridden with the .SET ERRORLEVEL command, that information is displayed.
User Error Mapping produces the same information for any error codes which are not usually supported, but have been added. If no new error codes have been added, this section does not display.
Example
Use the following command to display the contents of the tables that map error codes to severity levels:
.show errormap
.set errorlevel 4155 severity 12
.set errorlevel 4800 severity 8
.show errormap
BTEQ Response
The following is an example of the output of the second .SHOW ERRORMAP command:
SYSTEM ERROR MAPPING
Errorcode Errorlevel
1 12
2 12
3 12
4 12
5 12
6 12
7 12
8 12
9 12
10 12
530 8
2123 8
2538 8
2541 8
2580 4
2631 0
2632 8
.... .
.... .
.... .
3807 8
3824 8
3873 8
3877 8
3897 8
3916 8
USER ERROR MAPPING
4155 12
4800 8
Example 2
The Example 1 SHOW ERRORMAP command in a Teradata SQL macro appears as:
ECHO '.SHOW ERRORMAP';