15.10 - ListErrorCodes - Teradata Database

Teradata Database SystemFE Macros

prodname
Teradata Database
vrm_release
15.00
15.10
category
Administration
featnum
B035-1103-015K

ListErrorCodes

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