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

Class Reference IRIS for UNIX 2024.1.2
Documentation Search