This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Home > Class Reference > %SYS namespace > %ResultSet.Static


class %ResultSet.Static extends %Library.IResultSet

A Static result set is one where the original data source (a result set object) is copied to a process private global upon instantiation. Future data requests then use that snapshot instead of the original data.

Method Inventory


method %Get(colname As %String = "") as %Library.String
Returns the value of the column with the name name in the current row of the result set.

If name is not a valid column name, this method returns an empty string.

method %GetData(colnbr As %Integer = 0) as %Library.String
Returns the value of column colnbr in the current row of the result set.
method %Next(ByRef sc As %Library.Status = $$$OK) as %Library.Integer
Advance the result set cursor to the next row. Returns 0 if the cursor is at the end of the result set. The global structure consists of a base $list with individual nodes for columns. The base $list() can contain zero or more column values. Additional column values are stored in the global subscripted by column number and equal to the column value.
method %ROWCOUNTGet() as %Integer
%RowCount for a static result set is always the number of rows in the static set.
method %SendODBC() as %Library.Integer
Fetch and send a series of rows for the ODBC/JDBC server. For internal use only.
method %SendRows() as %Integer
method %SetIterator(pRowNumber As %Library.Integer = 0) as %Library.Integer

Inherited Members

Inherited Properties

Inherited Methods

FeedbackOpens in a new window