Archives of the TeradataForum
Message Posted: Wed, 17 Mar 1999 @ 16:00:39 GMT
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?
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023