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

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;';
  );