All Forums Database
Vinodraj 12 posts Joined 01/13
21 Jul 2014
How to check what values are passed to procedure call from qrylog table ?

Hi,
 
This is regarding, how do I find values passed in the stored procedure call from qrylog table.
 
From dbc.qrylog, I could see all the procedure names made through TD. However, I could not see values passed to the procedure. In the QueryText field from qrylog, I see the values as a question mark instead of values.
 
Call MyPROC(?, ?, ?)
 
How do I find what is the values passed to this MyPROC procedure call.
 
Thanks in advance for your help.
 
Many thanks,
Vinod

-

Vinod

Tags:
ulrich 816 posts Joined 09/09
21 Jul 2014

you have to change your SP to log the information. Using queryband could be efficient
for example
SET QUERY_BAND = "PROCEDURE_NAME=yourSP;PROCEDURE_IN_PARAM=param1name:param1value|param2name:param2value' UPDATE FOR TRANSACTION;
 
you would need to create this string with the input parameters and call the set query_band as firt call. 
I recommend to use update for transaction as this will not override any other queryband parameter which might exists...

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Vinodraj 12 posts Joined 01/13
22 Jul 2014

Thanks for the insight  ! This helps.
 

-
Vinod

dnoeth 4628 posts Joined 11/04
22 Jul 2014

DQBL has been enhanced in TD15 to write this info into a new dbc.DBQLParamTbl:
BEGIN QUERY LOGGING WITH PARAMINFO

Dieter

You must sign in to leave a comment.