Examples: Using QryLogClientAttrV - Teradata Vantage

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
[…]