Archives of the TeradataForum

Message Posted: Fri, 07 Apr 2006 @ 18:03:09 GMT

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

<-- Anonymously Posted: Friday, April 07, 2006 14:01 -->

Ack! It's generally not a good idea to qualify DBQL queries on CollectTimestamp, because that actually applies to buffer initialization and not to inserting individual rows.

Apart from that, note that DBQL can only answer the original poster's question if you already have DBQL active at the Object level for all users / accounts.

          > Query
          >
          > select databasename, tablename from DBC.Tables where Tablekind = 'T'
          > minus
          > select objectdatabasename, objecttablename
          > from DBC.DBQLOBJTBL
          > where objectype = 'T'
          > And collectTimestamp between **** your time frame *****

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