Archives of the TeradataForum

Message Posted: Wed, 17 Mar 1999 @ 16:00:39 GMT

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

To kick off this wonderful new list, I have a question about accesslogging.

Let's say you have a database of tables, and a database of views on the tables. Access logging is turned on only for the database of tables like this:

     begin logging with text on each select on database DBT;

Run some selects against the views in the "views" database DBV. These are views on the database of tables.

You get rows in the accesslog table showing that there are hits against the views, but no text of the SQL statement - what do you need to do to see the SQL text?

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