This class has been superseded. It will remain for compatibility with existing code and samples. We recommend using %SQL.Statement.Simple resultset object that does not contain any rows, but just contains the result information
Display the contents of this object on the current device 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. method %GetData(colnbr As %Integer = 0) as %Library.String
If name is not a valid column name, this method returns an empty string.
Returns the value of column n 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. classmethod %Prepare(queryId As %String(MAXLEN=""), ByRef %returnError As %SYSTEM.Error, %importPackages As %RawString = "", %args...) as %Library.IResultSet
%Prepare() method %SendODBC() as %Library.Integer
This method is different for each type of result set class. This method has two tasks. First, instantiate the correct concrete result set class. Think of the first parameter, queryId, as being an "index key value" that is used to lookup the correct query implementation. For non-cached (static) queries this is simply the name of the class that implements the query, i.e. the %IResultSet interface. The second task is to prepare the resulting object for data retrieval by the caller.
This can be the concrete subclass of %IResultSet that implements the desired query. For dynamic cached results this value is generally the query text that can be parsed, a hashed value computed and the cached result implementation class looked up in the query cache index.
queryId can also be a <className><colon><queryName> or <className><colon><methodName>. If it is a <queryName> then the result set returned is an instance of %Library.ResultSet that is bound to that query. If it is the name of a method Then that method is called, passing %args... to the method, and the first result set found in the context object (%sqlcontext) is returned.
%returnError %importPackages This is a comma delimited list of packages to import. This is only relevant if the result set implementation is generated and the query source might include unqualified names. The import packages list is used to resolve package/schema names for unqualified names.
Argument values to be passed to the query/method/class %Execute() method. Zero, one or more argument values can be passed.
Fetch and send a series of rows for the ODBC/JDBC server. For internal use only.