Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Posts
    56

    Unanswered: How to find out bind variable value

    Hi,
    Is there a way to find the value using on bind variable?

    If i have code like : select * from worktab where calnum = :L0 and shiftnum = :L1
    How can i know what exactly was the value in :L0 ,:L1 ?

    Many thanks !!

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    You can use the event monitor for activities for this.
    Collecting data for individual activities
    Use the following statement to capture the statements of the connection with an <APPLICATION_HANDLE> needed:
    Code:
    CALL WLM_SET_CONN_ENV(<APPLICATION_HANDLE>, '<collectactdata>WITH DETAILS AND VALUES</collectactdata>');
    You can find your values in the table which you specified for the event monitor group ACTIVITYVALS.
    See CREATE EVENT MONITOR (activities) statement
    Regards,
    Mark.

  3. #3
    Join Date
    Oct 2010
    Posts
    56
    Hi Mark,
    Thank you for the replay !!

Posting Permissions

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