How to check what values are passed to procedure call from qrylog table ?

Database
Enthusiast

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

Tags (1)
3 REPLIES
Supporter

Re: How to check what values are passed to procedure call from qrylog table ?

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

Enthusiast

Re: How to check what values are passed to procedure call from qrylog table ?

Thanks for the insight  ! This helps.

Junior Contributor

Re: How to check what values are passed to procedure call from qrylog table ?

DQBL has been enhanced in TD15 to write this info into a new dbc.DBQLParamTbl:

BEGIN QUERY LOGGING WITH PARAMINFO