16.20 - Examples: Using QryLogClientAttrV - 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

Example: Count the Number of Rows Stored in QryLogClientAttrV

The following SELECT statement counts all the rows stored in QryLogClientAttrV.

SELECT count(*) FROM dbc.qrylogclientattrv;

Result:

  Count(*)
-----------
          3

Example: SELECT All Rows

The following SELECT statement retrieves all the rows stored in QryLogClientAttrV.

SELECT * FROM dbc.qrylogclientattrv;

Result:

                       QueryID   307181787909344876
                       DateFld 16/03/02
                       TimeFld 07:26:04.68
                      UserName USER1
                   AccountName DBC
                         Event Logon
                 LogicalHostId      1
                         IFPNo  30718
                     SessionNo          1,465
                     LogonDate 16/03/02
                     LogonTime 07:26:04.64
[…]
                       QueryID   307181787909344874
                       DateFld 16/03/02
                       TimeFld 07:25:56.62
                      UserName DBC
                   AccountName DBC
                         Event Logon
                 LogicalHostId      1
                         IFPNo  30718
                     SessionNo          1,464
                     LogonDate 16/03/02
[…]
                       QueryID   307181787909344878
                       DateFld 16/03/02
                       TimeFld 07:26:08.04
                      UserName DBC
                   AccountName DBC
                         Event Logon
                 LogicalHostId      1
                         IFPNo  30718
                     SessionNo          1,466
                     LogonDate 16/03/02
[…]