We are having some issues in our development shop, and I wanted to know if there is any way to see the parameters passed in a query in the odbc log. I have turned debug on, and I am getting a log of all of the queries. I see the parameters after they are added into the query, but I would like a listing of each parameter value before the query substitution occurs. Is there anyway to see this?
Example: PGAPI_Execute: clear errors... PGAPI_Execute: copying statement params: trans_status=2, len=75, stmt='UPDATE CLMCOM1 SET SUBMIT_L_NAME_ORG = ? WHERE INV_NBR = ? AND INV_QFR = ? ' copy_statement_with_params: from(fcType)=1, to(fSqlType)=1 -- IS THERE ANYWAY TO SEE THIS PARAM VALUE HERE? copy_statement_with_params: from(fcType)=4, to(fSqlType)=4 -- IS THERE ANYWAY TO SEE THIS PARAM VALUE HERE? copy_statement_with_params: from(fcType)=1, to(fSqlType)=1 -- IS THERE ANYWAY TO SEE THIS PARAM VALUE HERE?