The scrollable cursor feature provides a way to set the current position anywhere in the result set by specifying a NEXT, PREVIOUS, FIRST, LAST, ABSOLUTE or RELATIVE clause in a FETCH statement. It implements a scrollable cursor that is read-only with either an INSENSITIVE or a SEMI_SENSITIVE property.
Non-scrollable, insensitive cursors are also supported on Open Server and are set with the CS_NOSCROLL_INSENSITIVE option.
A new capability, CS_REQ_CURINFO3, is added to Open Server to support the new scrollable cursor feature. During login, CS_REQ_CURINFO3 allows a remote client connecting to Open Server to request scrollable cursor support.
