Logging select statements

Database
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
Senior Apprentice

Re: Logging select statements

Query Log is independent of the session mode.

What exactly are you doing?

 

Enthusiast

Re: Logging select statements

I want to track the recent queries executed by the users with the user details in ANSI mode but the QryLog tables do not seem to be populated in this mode. But if I change to "TERA" mode and execute few queries in it, the QryLog tables get populated. I just want to know how can i track them in ANSI mode. I am using teradata 14. 

Senior Apprentice

Re: Logging select statements

What's the exact Select you use?

If you run it in an ANSI session remember: string comparison is case sensitive.