Readpast locking for queue processing  Incompatible locks during readpast queries

Chapter 21: Locking Commands and Options

readpast syntax

The syntax for using readpast locking is:

{select | update | delete} ...
     from tablename [holdlock | noholdlock] 
          [readpast] [shared]
          ...
readtext [[database.]owner.]table_name.column_name
     text_pointer offset size 
     [holdlock | noholdlock] [shared] [readpast]
          ...
writetext [[database.]owner.]table_name.column_name
     text_pointer [readpast] [with log] data




Copyright © 2005. Sybase Inc. All rights reserved. Incompatible locks during readpast queries

View this book as PDF