Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 31 Jul 2015 @ 19:39:01 GMT


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


Subj:   Re: Parameters that get passed in a SP
 
From:   Dieter Noeth

Roopalini Bakthavachalam wrote:

  Forum - Does the parameters that we pass in a store procedure get saved in any of the DBQL tables. I don?t see that getting saved in the DBQLOGTBL querytext. Do we need to enable something to make sure the parameters are saved?  


Starting with TD15 BEGIN QUERY LOGGING WITH PARAMINFO will enable this, the actual data can be found in JSON format in dbc.QryLogParamV.


Dieter



     
  <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