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.
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.