Skip to main content

%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

Method Inventory

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()

Inherited Members

Inherited Methods

FeedbackOpens in a new tab