Scripting and Programming Guides › Developer's Guide for Java › Delegated Management Services API › Cursor Class

Cursor Class

The SmDmsCursor class lets you define sorting and paging behavior for result set operations—for example:

• Set the sort parameter of the SmDmsCursor constructor to specify the columns to use for sorting rows.
• Call setBlockSize() to define the maximum number of rows that can be returned from a result set at one time—that is, the maximum number of rows in a page.
• Call setOffset() to specify the starting offset (row number) of the block returned from the result set.
• Call isSortingCritical() to specify whether a result set must be sorted.
  • If you specify true, a result set will be retrieved only if it can be sorted.
  • If you specify false, an unsorted result set will be sent if it cannot be sorted. An isSorted() call on the same SmDmsCursor object will return false.
• Call isPagingCritical() to specify whether a result set must be paginated.
  • If you specify true, a result set will be retrieved only if it can be paginated.
  • If you specify false, a complete result set will be sent if it cannot be sorted. An isPaginated() call on the same SmDmsCursor object will return false.