Hi all,

Anyone know how I can trace what variables have been passed to s Stored Proc ? The statement monitor passed the SQL in the SP, but not the actual variables passed.

I'm running DB2 Express v8.2 on Windows 2003

Any help appreciated.

You can modify the stored procedure code to write the values out to a log file or to return them via OUT parameters.

Thanks for the reply. I was hoping to do this in a production system, so not able to amend the actual SP.

any other ideas ?