17.10 - Example: Using QryLogExceptionsV - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

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 ?