Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Posts
    60

    Unanswered: Cursor was blocking: TRUE

    Hi All,

    We are using version 8.1 on aix and created stament event monitor to capture SQLs.

    What does Cursor was blocking: TRUE mean?

    thanks
    j

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    A blocking cursor ..

    ie , the resultset of the curosr was returned to the calling application in blocks of rows rather than one row at a time ..

    This will normally happen when the SQL statement in the cursor is read-only or the cursor is explicitly defined 'FOR FETCH ONLY' ...

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2003
    Posts
    60
    thanks sathya. where can i find such internal reference and the details.
    do you have any link?

    Thanks,
    j

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    All this information is in the IBM documentation ...

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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