16.20 - Example: Using QryLogExceptionsV - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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 ?