%ML.DeferredStatement

class %ML.DeferredStatement extends %Library.RegisteredObject

Deferred version of a %SQL.Statement. This class is a facade for %SQL.Statement and as such implements the %SQL.Statement interface

Property Inventory

%Message
%SQLCODE
Args
SQL
SQLCOUNT

Method Inventory

%ExecDirect()
%Execute()
%Next()
%Prepare()

Properties

property %Message as %Library.String (MAXLEN = 256);

%Message contains additional information about an error reported as a negative value in %SQLCODE. Additional information is not always available.

Property methods: %MessageDisplayToLogical(), %MessageGet(), %MessageIsValid(), %MessageLogicalToDisplay(), %MessageLogicalToOdbc(), %MessageNormalize(), %MessageSet()

property %SQLCODE as %Library.Integer [ InitialExpression = 0 ];

%SQLCODE indicates whether or not the statement was executed successfully. If %SQLCODE is not negative (greater than or equal to zero) then the statement was successfully executed. Otherwise, the value of %SQLCODE contains the error code and the %Message property might contain more information about the error.

Property methods: %SQLCODEDisplayToLogical(), %SQLCODEGet(), %SQLCODEIsValid(), %SQLCODELogicalToDisplay(), %SQLCODENormalize(), %SQLCODESet()

property Args as %String [ MultiDimensional ];

Any query args

Property methods: ArgsDisplayToLogical(), ArgsGet(), ArgsIsValid(), ArgsLogicalToDisplay(), ArgsLogicalToOdbc(), ArgsNormalize(), ArgsSet()

property SQL as %String [ MultiDimensional ];

SQL statement

Property methods: SQLDisplayToLogical(), SQLGet(), SQLIsValid(), SQLLogicalToDisplay(), SQLLogicalToOdbc(), SQLNormalize(), SQLSet()

property SQLCOUNT as %String [ MultiDimensional ];

SQL statement to count result set rows

Property methods: SQLCOUNTDisplayToLogical(), SQLCOUNTGet(), SQLCOUNTIsValid(), SQLCOUNTLogicalToDisplay(), SQLCOUNTLogicalToOdbc(), SQLCOUNTNormalize(), SQLCOUNTSet()

Methods

classmethod %ExecDirect(ByRef StmtHandle As %SQL.Statement = $$$NULLOREF, ByRef %statement As %RawString = "", ByRef %statementcount As %RawString = "", %parm...) as %SQL.StatementResult

Facade for %SQL.Statement:%ExecDirect Note, returns $THIS as it's not a real resultset, but it'll get passed into the ML provider.

method %Execute(%parm...) as %SQL.StatementResult

Facade for %SQL.Statement:%Execute Note, returns $THIS as it's not a real resultset, but it'll get passed into the ML provider.

method %Next(ByRef sc As %Status) as %Integer

No-op implementation of this

method %Prepare(ByRef %statement As %String) as %Status

Facade for %SQL.Statement:%Prepare()

%ML.DeferredStatement

Property Inventory

Method Inventory

Properties

Methods

Inherited Members

Inherited Methods