Metadata describes the statement interface. The statement metadata contains the type of statement, the number of
columns defined by the statement and the metadata for each column. Statement columns are of three primary types:
result columns, parameters, and the return value. There is also a distinction between the metadata available for a
prepared statement and for a statement that has been executed since not all statement results are known at prepare
time. For all statement types except CALL, the statement metadata is all available at prepare time. CALL statement metadata
that is available at prepare time includes the metadata from the statement itself and that metadata is not to be confused
with the metadata defined by the SQL routine that is called. Each routine defines a formal interface that consists of an
optional return value and option input, input-output and output parameters. An SQL routine might also return a single
preplanned result set. That metadata is available at prepare time and it consists of some number of columns of type
SQLRESULTCOL. An SQL routine might also declare that it returns some dynamic result sets, the metadata for which is not
available until after the statement is executed and the result sets bound dynamic cursors.
columns is a collection of StatementColumn objects. Each StatementColumn object
contains the metadata a column defined by the statement as an SQLRESULTCOL column type.
formalParameters is a collection of '?' parameters found in the prepared statement.
It may differ from the parameters collection if literal replacement occurred. This
property is mainly for internal use and metadata reporting. It is not meant to be used
for the statement descriptor.
interface is an integer value indicating the routine interface:
-2 - Return value, dynamic cursors returned (zero, one or more)
-1 - No return value, dynamic cursors returned (RETURNRESULTSETS, zero one or more)
0 - No return value, no dynamic cursors (NOT RETURNRESULTSETS, aka "function" procedure although a function should return a value (interface = 2))
1 - No return value, one pre-planned result set (AKA "query" procedure)
2 - Return value, no dynamic cursors (NOT RETURNRESULTSETS)
The parameters collection contains the metadata for each actual parameter
contained in the source statement. ..parameters.Count() is equivalent to the
number of '?' parameters found in the source statement and the list position
corresponds to the ordinal position of the '?' in the source statement.
classmethod %GenerateMetadata(ByRef pInfo As %Binary, pStatementType As %Integer = 0, ByRef pMetadata As %Binary, ByRef pParameters As %Binary = "", ByRef pObjects As %Binary, ByRef pActual As %List = "", ByRef pDynamic As %List = "") as %Status
GenerateMetadata constructs the serialized metadata from the query processor's info array.
IF %protocol 41 and higher:
metadata = $lb()
1 - # of SELECT columns
2 - i:
1) Name
2) ODBC Type
3) Precision
4) Scale
5) NULLABLE (integer)
6) Column Label (same as Name)
7) Column Table Name
8) Column Schema Name
9) Column Qualifier Name - NULL
10) $Char(1)/$Char(0) string / $Extract position:
1) isAutoIncrement
2) isCaseSensitive
3) isCurrency
4) IsReadOnly
5) IsRowVersion
6) IsUnique
7) IsAliased
8) IsExpression
9) IsHidden
10) IsIdentity
11) IsKeyColumn
12) IsRowid // DPV3092
j - # of Parameters
j+1 - k:
1) ODBC Type
2) Precision
3) Scale
4) NULLABLE
5) colName
6) colType
IF %protocol less than 41:
metadata = $lb()
1 - # of SELECT columns
2 - i:
1) Name
2) ODBC Type
3) Precision
4) Scale
5) NULLABLE
6) Column Label (same as Name)
7) Column Table Name
8) Column Schema Name
9) Column Qualifier Name - NULL
j - # of Parameters
j+1 - k:
1) ODBC Type
2) Precision
3) Scale
4) NULLABLE
private method %OnNew(pStatementType As %Integer = 0, ByRef pMetadata As %Binary = "", pParameters As %Binary = "", pObjects As %Binary = "", pArguments As %Binary = "", pActualBinding As %List = "", pDynamic As %List = "") as %Status
This callback method is invoked by the %New() method to
provide notification that a new instance of an object is being created.
If this method returns an error then the object will not be created.
It is passed the arguments provided in the %New call.
When customizing this method, override the arguments with whatever variables and types you expect to receive from %New().
For example, if you're going to call %New, passing 2 arguments, %OnNew's signature could be:
Method %OnNew(dob as %Date = "", name as %Name = "") as %Status
%SQL.StatementMetadata is a metadata class for dynamic statement metadata. The initial value is the metadata from a StatementCache object.
or it is the result set object itself.
pMetadata describes only the ROWTYPE metadata for a result set. Additional metadata is contained in pParameters and pObjects.
The non-ROWTYPE metadata is a single node for non-result columns (in pParameters) and a single node for object metadata (in pObjects).