IBM® Informix® 12.10

Hold cursors that use PDQ

When hold cursors that are created by declaring the WITH HOLD qualifier have no locks, PDQ is enabled.

PDQ will be set for hold cursors in the following cases:
  • Queries with Dirty Read or Committed Read isolation level, ANSI, and read-only cursor
  • Queries with Dirty Read or Committed Read isolation level, NON-ANSI, non-updateable cursor
Parent topic: Database server operations that use PDQ

Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.