Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    1

    Unanswered: How to get the last executed SQL command for each DB connection

    Hello,

    I am using DB2 8.2. And I am wondering how to get the last executed SQL command for each DB connection. I tried to get snapshot, but it seems that no such information can be retrieved from DB2 snapshot. Please advise if any related mechanism available. Thanks a lot.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look at the SNAPSHOT_STATEMENT function. You can find out about it by looking at the online documentation located at:

    http://publib.boulder.ibm.com/infoce.../v8//index.jsp

    Look in the Reference->SQL->Functions->Table Functions

    HTH

    Andy

Posting Permissions

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