If the readpast option is specified for an allpages-locked table, the readpast option is ignored. The command operates at the isolation level specified for the command or session:
If the isolation level is 0, dirty reads are performed, and the command returns values from locked rows, and does not block.
If the isolation level is 1 or 3, the command blocks when pages with incompatible locks must be read.
Copyright © 2005. Sybase Inc. All rights reserved. |