Archives of the TeradataForum

Message Posted: Thu, 13 Nov 2003 @ 15:50:18 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The other responses are correct - Use Access Logging or Query Logging if you want to log everything for a user.

If you want to be more selective - log the SQL only under certain conditions - you can use the monitor object to write a simple app. Use the GetSession() method to fetch all the sessions and decide which ones you want to know the SQL for. Then call GetSessionSQL() for those sessions.

Note that this will only work for relatively long running queries since the query must still be running when the GetSessionSQL() function is called (This is real time data.)

Mike Dempsey
Teradata Client Tools

	<Prev	Next>		<<First	<Prev	Next>	Last>>