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

Summary

Properties
ODBCType	colName	columnType	isNullable	precision
scale

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

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;

Class Reference IRIS for UNIX 2024.1.2
Documentation Search