Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Access Logging on Views Required?
 
From:   Paul Lowder

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016