Checking the number of rows fetched  Updating cursor result set rows

Chapter 18: Cursors: Accessing Data

Updating and deleting rows using cursors

If the cursor is updatable, use the update or delete statement to update or delete rows. Adaptive Server determines whether the cursor is updatable by checking the select_statement that defines the cursor. You can also explicitly define a cursor as updatable with the for update clause of the declare cursor statement. See “Making cursors updatable” for more information.





Copyright © 2005. Sybase Inc. All rights reserved. Updating cursor result set rows

View this book as PDF