Logging Select Statements

Teradata Studio
Enthusiast

Logging Select Statements

Hi

 

Is there any way to log/monitor the recent select queries executed by users by which we can get the query, user and time related details In the ANSI mode.

 

i have checked the dbc.QryLog, but it works only for BTEQ mode.

Is there any way of logging select statements in ANSI Mode.

3 REPLIES
Junior Supporter

Re: Logging Select Statements

Hi.

 

Which version are you on?

 

On TD 15 you can do:

 

SELECT * FROM Dbc.DBQLogTbl WHERE TxnMode = 'ANSI';

 

TD14 Dbc.DBQLogTbl has no TxnMode column, but the content is stored in column "ExtraField21":

 

SELECT * FROM Dbc.DBQLogTbl WHERE ExtraField21 = 'ANSI';

 

 

Cheers.

 

Carlos.

Teradata Employee

Re: Logging Select Statements

Please post your question to the Database Product Forum. thanks.

Enthusiast

Re: Logging Select Statements

I am using 14 and in this i get no records in the table in ANSI mode