Chapter 4Scrollable Cursors

In this chapter we start with background information on the scrollable cursor. The chapter continues to explain how to declare scrollable and sensitive cursors, and how to manipulate the scrollable cursor. The chapter will provide the reader with information on the rules associated with scrollable cursors, along with an overview of the new global variables for scrollable cursors. The reader will be advised of situations where the new cursor functionality will impact tempdb. The chapter contrasts the different cursor worktable materializations between sensitive and insensitive cursors, and demonstrates how a sensitive cursor can behave in an insensitive manner. This chapter concludes with a brief note on the future ...

Get The Official New Features Guide to Sybase ASE 15 now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.