Hold Cursors That Use PDQ

When hold cursors 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