Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    10

    Unanswered: Tracing Stored proc variables

    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.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You can modify the stored procedure code to write the values out to a log file or to return them via OUT parameters.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    May 2004
    Posts
    10
    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 ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •