Using Result Sets
The EnsLib.SQL.GatewayResultSetOpens in a new tab class represents a special-purpose result set for use in InterSystems IRIS®. An initialized instance of this class has a live data connection to a data source. The class provides methods to examine the contents of the result set as well as a method to return a static snapshot.
This topic describes how to use the EnsLib.SQL.GatewayResultSetOpens in a new tab class.
Note that you can also get a snapshot that contains rows from the result set; see Using Snapshots.
Examining the Current Row of the Result Set
Use the following methods to examine the current row of the result set:
method Get(pName As %String) returns %String
Returns the value of the column that has the name pName, in the current row.
method GetData(pColumn As %Integer) returns %String
Returns the value of the column whose position is specified by pColumn in the current row.
method GetColumnName(pColumn As %Integer = 0)
Returns the name of the column whose position is specified by pColumn.
If the source data contains any unnamed columns, the result set automatically provides names for these columns in the following form: xCol_n