Class Reference
IRIS for UNIX 2019.2
InterSystems: The power behind what matters   
Documentation  Search
  [%SYS] >  [%SQL] >  [StatementParameter]
Private  Storage   

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;


Copyright (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.