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

%SQL.StatementParameter


serial class %SQL.StatementParameter extends
%SerialObject

%SQL.StatementParameter - metadata for a statement parameter. A StatementParameter instance contains the definition of a statement parameter. A statement parameter is a specific type of statement column. That type is defined in the columnType property. SQLRESULTCOL columns are not modeled as StatementParameter instances. Rather, a SQLRESULTCOL column is a StatementColumn instance.

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
6 1


Summary


Properties
ODBCType colName columnType isNullable precision
scale

Methods
%%OIDGet %AddToSaveSet %AddToSyncSet %BindExport
%BuildObjectGraph %ClassIsLatestVersion %ClassName %Close
%ConstructClone %Delete %DeleteId %DispatchClassMethod
%DispatchGetModified %DispatchGetProperty %DispatchMethod %DispatchSetModified
%DispatchSetMultidimProperty %DispatchSetProperty %Extends %GetParameter
%GetSwizzleObject %IncrementCount %IsA %IsModified
%IsNull %JournalObject %New %NormalizeObject
%ObjectIsNull %ObjectModified %OnBeforeAddToSync %OnDetermineClass
%Open %OpenId %OriginalNamespace %PackageName
%RemoveFromSaveSet %ResolveConcurrencyConflict %SerializeObject %SetModified
%SyncObjectIn %SyncTransport %ValidateObject LogicalToOdbc
OdbcToLogical getColInfo


Properties


• property ODBCType as %Integer;
• property colName as %String(MAXLEN=255);
• property columnType as %Integer(MAXVAL=5);
columnType is the ODBC column type: SQLPARAMTYPEUNKNOWN 0 SQLPARAMINPUT 1 SQLPARAMINPUTOUTPUT 2 SQLRESULTCOL 3 SQLPARAMOUTPUT 4 SQLRETURNVALUE 5 SQLRESULTCOL types are not StatementParameter instances. Rather, SQLRESULTCOL columns are StatementColumn objects.
• property isNullable as %Boolean;
• property precision as %Integer;
• property scale as %Integer;

Methods


• method getColInfo() as %Library.List
getColInfo returns an output column descriptor from a parameter definition if the parameter has output direction (types 2,4, and 5)