The nonstandard SDOResultSet methods listed in the following table support a variety of features unique to SmartDataObject management.

Note: The rowId value referenced in the following methods is equivalent to the value returned by the ABL ROWID function and the SDOResultSet.getRowIdentity() method.
Table 1. Nonstandard SDOResultSet management methods
Method Description 
boolean absolute
(String rowId) [Extension]
 Repositions the cursor at the row specified byrowId. 
String getQuery() [Extension]
 Returns the ABL query that populated this SDOResultSet object. 
String getRowIdentity() [Extension]
 Gets the string representation of the ROWID value for the current row that can be used as input to reOpenQuery(String rowId), absolute(String rowId), and SDOParameters.setRowIdentity(String rowId). 
SDOInterface getSDOInterface() [Extension]
 Provides direct access to the underlying ABL methods of the SmartDataObject that are efficient for remote SmartDataObject access. The returned SDOInterface is a ProcObject that includes all relevant public methods provided by the SmartDataObject. Thus, you have full access to these SmartDataObject features without any limit imposed by the SDOResultSet interface. If the SDOResultSet is stateless, calling getSDOInterface() creates a remote SmartDataObject procedure you can delete only by calling releaseSDOInterface(). Calling releaseSDOInterface() on a non-stateless SDOResultSet has no effect.

See Note on SDOInterface method.

 
void releaseSDOInterface() [Extension]
 On a stateless SDOResultSet, releases the remote SmartDataObject procedure. Calling releaseSDOInterface() on an SDOResultSet that is not Stateless has no effect. This method is used in conjunction with getSDOInterface(). 
void reOpenQuery() [Extension]
 Reopens the SmartDataObject query and positions the cursor before the first row. This method refreshes all the data in the SDOResultSet, makes all of the newly inserted rows visible, and removes all of the deleted rows. Any local modifications that you have not sent to the application server before you call this method are lost. 
void reOpenQuery
(String rowId) [Extension]
 Works like reOpenQuery(), but the first row returned is the one specified byrowId. A null rowId is equivalent to reOpenQuery(). Usually it is more efficient to call reOpenQuery(String rowId) than to first call reOpenQuery() and then call absolute(String rowId) to reposition on the specified row.
Note: If the SDOResultSet is in SDOScrollingMode.PREFETCH mode, you cannot get the rows before this rowId. For more information on SDOScrollingMode.PREFETCH, see Understand SDOResultSet scrolling modes.