An SDOParameters object in com.progress.open4gl can be supplied as a parameter to the SDOResultSet factory method that allows you to control various ResultSet properties. You need to set only the values that differ from the defaults. The methods to set and get these values on the SDOParameters object follow.

The following method sets the row ID of the first row to be fetched from the created and opened SDOResultSet:

void setRowIdentity(String rowId)

A null rowId is equivalent to not calling setRowIdentity() (also see the reOpenQuery(String rowId) extended method in Miscellaneous management methods. Usually, it is more efficient to use setRowIdentity() than to create the SDOResultSet and then call the extended method, absolute(String rowId), to reposition the cursor on the specified row.

If you create the SDOResultSet in PREFETCH scrolling mode, you cannot access rows before the rowId that you set with setRowIdentity(). For more information on PREFETCH, see Understand SDOResultSet scrolling modes.

The rowId value is equivalent to the value returned by the ABL ROWID function and the SDOResultSet.getRowIdentity() method. For more information on ROWID, see Develop ABL Applications or the appropriate OpenEdge DataServer Guide for any DataServer accessed by the SmartDataObject. For more information on the SDOResultSet.getRowIdentity() method, see Miscellaneous management methods.

The following method gets the row ID of the first row to be fetched from the created and opened SDOResultSet:

Syntax

String getRowIdentity()

The following method sets the number of rows the scrolling mechanism fetches each time it accesses the application server:

Syntax

void setFetchSize(int fetchsize)

The default is 200.

The following method gets the number of rows the scrolling mechanism fetches each time it accesses the application server:

Syntax

int getFetchSize()

The following method sets the Stateless mode for the SDOResultSet:

Syntax

void setStateless(boolean state)

Specify stateas true for a stateless SDOResultSet and false for a non-stateless SDOResultSet. For more information, see Understand SDOResultSet stateless mode.

The following method gets the Stateless mode for the SDOResultSet:

Syntax

boolean getStateless()

For more information, see Understand SDOResultSet stateless mode.

The following method sets the scrolling mode for the SDOResultSet specified as a class constant in com.progress.open4gl.SDOScrollingMode:

Syntax

void setScrollingMode(SDOScrollingMode constant)

If the SDOResultSet is Stateless, the default is SDOScrollingMode.PREFETCH; otherwise, the default is SDOScrollingMode.KEEP_ROWS. The other supported scrolling mode is SDOScrollingMode.FORWARD_ONLY. For more information, see Understand SDOResultSet scrolling modes.

The following method gets the scrolling mode specified for the SDOResultSet, returned as a class constant in com.progress.open4gl.SDOScrollingMode:

Syntax

SDOScrollingMode getScrollingMode()

For more information, see Understand SDOResultSet scrolling modes.

The following method sets the maximum number of rows to be fetched when the scrolling mode is SDOScrollingMode.PREFETCH:

Syntax

void setPrefetchMaxRows(int maxRows)

The setPrefetchMaxRows() method has no effect for scrolling modes other than SDOScrollingMode.PREFETCH. The default for this mode is to get all the rows of the SDOResultSet. For more information, see Understand SDOResultSet scrolling modes and Understand SDOResultSet stateless mode.

The following method gets the value for the maximum number of rows to be fetched when the scrolling mode is SDOScrollingMode.PREFETCH:

Syntax

int getPrefetchMaxRows()

For more information, see Understand SDOResultSet scrolling modes and Understand SDOResultSet stateless mode.