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

%SQL.CSVResultSet


%SQL.CSVResultSet is a hidden class, internal to ISC, that provides the basic functionality necessary to bind a result set to an external data source that is in csv format. This class is hidden because users need not be aware that it exists. To prepare a new CSV-bound result set it is only necessary to call a method in %SQL.DynamicStatement. Refer to that class for more information.

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
8


Summary


Properties
%CurrentResult %Message %Metadata %OutputColumnCount
%PrivateTables %ROWCOUNT %ROWID %ResultColumnCount
%SQLCODE %StatementType %StatementTypeName

Methods
%ClassIsLatestVersion %ClassName %ConstructClone %DispatchClassMethod
%DispatchGetModified %DispatchMethod %DispatchSetModified %DispatchSetMultidimProperty
%Display %DisplayFormatted %Extends %Get
%GetData %GetMetadata %GetParameter %IsA
%IsModified %MoreResults %New %Next
%NextOutputValue %NextResult %NormalizeObject %ObjectModified
%OriginalNamespace %PackageName %Print %SendODBC
%SerializeObject %SetModified %ValidateObject Close
Fetch FetchRows GetInfo GetODBCInfo
getSelectMode parseString


Methods


• method %Get(pColumnName As %String) as %String
Returns the value of the column with the name pColumnName in the current row of the result set.

If pColumnName is not a valid column name, this method throws a error.

• method %GetData(pColumnNbr As %Integer = 0) as %String
Returns the value of column colnbr in the current row of the result set.
• method %SendODBC() as %Integer
Fetch and send a series of rows for the ODBC/JDBC server. For internal use only.
• method parseString(in, del, quote, return, ByRef continue, ByRef stream=0, term="")