Archives of the TeradataForum

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

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

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>>