17.00 - Example: Using QryLogExceptionsV - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

The following SELECT statement retrieves the view for QryLogExceptionsV:

SELECT * from DBC.QryLogExceptionsV;

The query returns the following result:

            ProcID 16383
CollectTimeStamp 2004-06-21 16:38:34.21
        QueryID 201205134619838011
          UserName TEST1
         SessionID ?
        RequestNum ?
     LogicalHostID 1
        AcctString DBC
              WDID ?
           OpEnvID ?
          SysConID ?
ClassificationTime ?
     ExceptionTime 2004-06-21 17:38:34.21
    ExceptionValue ?
   ExceptionAction ?
           NewWDID ?
     ExceptionCode 3,152
  ExceptionSubCode ?
         ErrorText  No access allowed, For all requests, For user TEST1,
                    Regulation applies from 00:00 to 24:00
         ExtraInfo ?
      RuleID ?
    WarningOnly ?
   RejectionCat ?