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

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

thanks sathya. where can i find such internal reference and the details.
do you have any link?

Thanks,
j

All this information is in the IBM documentation ...

Cheers
Sathyaram