ListErrorCodes Macro | SystemFE Macros | Teradata Vantage - 17.00 - 17.05 - ListErrorCodes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Administration
Publication ID
B035-1103-170K
Language
English (United States)
REPLACE MACRO SystemFE.ListErrorCodes AS
  (
  echo 'set defaults;';
  echo 'set format on;';
  echo 'set width 80;';
  echo 'set NULL as "-";';
  echo 'set separator 2;';
  echo 'set pagelength 60;';
  echo 'set heading "&DATE||Error Code Summary||&TIME";';
  Select   ErrorCode (Format '---,--9')
         , ErrorText
  From     DBC.ErrorMsgs
  Where    ErrorCode > 0000
  Order By ErrorCode;
  echo 'set defaults;';
  );