Learning
Documentation
Community
Open Exchange
Global Masters
Home / Class Reference / %SYS namespace / %ResultSet.Static
Private  Storage   

%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.

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
9


Summary


Properties
%Message %Metadata %PrivateTables %ROWCOUNT
%ROWID %ResultColumnCount %SQLCODE

Methods
%AddToSaveSet %ClassIsLatestVersion %ClassName %ConstructClone
%CreateSnapshot %DispatchClassMethod %DispatchGetModified %DispatchGetProperty
%DispatchMethod %DispatchSetModified %DispatchSetMultidimProperty %Display
%DisplayFormatted %Extends %Get %GetData
%GetMetadata %GetParameter %IsA %IsModified
%New %Next %NormalizeObject %ObjectModified
%OriginalNamespace %PackageName %Prepare %PrepareMetaData
%Print %ROWCOUNTGet %RemoveFromSaveSet %ResultColumnCountGet
%SendDelimitedRows %SendODBC %SendRows %SerializeObject
%SetIterator %SetModified %ValidateObject

Subclasses

Methods


• 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