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.
you have to change your SP to log the information. Using queryband could be efficient
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...
DQBL has been enhanced in TD15 to write this info into a new dbc.DBQLParamTbl:
BEGIN QUERY LOGGING WITH PARAMINFO