Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 26 Jul 2013 @ 15:27:42 GMT


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


Subj:   DBQL log with enabled object logging is not
 
From:   td newsgroup

Hi all,

on my system I have DBQL object logging enabled for my user.

I run a simple delete within a SP.

     DELETE FROM mydb.tableA;

I find the statement in the qrylog view. But there is no record for the queryid in dbc.qrylogobjects.

I would have expected to find there a record for mydb.tablea.

This is on 13.10

And for other queries of the same SP objects are found in dbc.qrylogobjects. But not for all.

Is there an issue with SP and Object logging?


Ulrich



     
  <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