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

Teradata Vantageā„¢ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Publication ID
B035-1103-171K
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;';
  );