16.20 - ListErrorCodes - Teradata Vantage NewSQL Engine

Teradata Vantage™ SystemFE Macros

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
featnum
B035-1103-162K
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;';
  );