Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 03 Mar 2008 @ 18:08:28 GMT

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

Subj:   Re: DBQL - Query Id in Objects table but not in QueryLog
From:   Mankala, Mahesh


You can find query with the help of queryID in DBC.QryLogObjects. You can query the DBC.QryLog table with queryID='123456' for the sql text.


     select QueryText from DBC.QryLog where QueryID='123456';

-Mahesh Mankala

  <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: 23 Jun 2019