15.10 - ListErrorCodes - Teradata Database

Teradata Database SystemFE Macros

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

);