Skip to main content

%SQL.StatementMetadata

class %SQL.StatementMetadata extends %Library.RegisteredObject

For details on using this class, see SQL Metadata.

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.

Property Inventory

Method Inventory

Properties

property columnCount as %Integer;
The number of columns defined as SQLRESULTCOL that are returned by executing this statement. This is the same as columns.Count().
Property methods: columnCountDisplayToLogical(), columnCountGet(), columnCountIsValid(), columnCountLogicalToDisplay(), columnCountNormalize(), columnCountSet()
property columnIndex as %String) [ MultiDimensional ];
Index on column names and column number.
Property methods: columnIndexDisplayToLogical(), columnIndexGet(), columnIndexIsValid(), columnIndexLogicalToDisplay(), columnIndexLogicalToOdbc(), columnIndexNormalize(), columnIndexSet()
property columns as list of %SQL.StatementColumn;
columns is a collection of StatementColumn objects. Each StatementColumn object contains the metadata a column defined by the statement as an SQLRESULTCOL column type.
Property methods: columnsBuildValueArray(), columnsCollectionToDisplay(), columnsCollectionToOdbc(), columnsDisplayToCollection(), columnsGet(), columnsGetObject(), columnsGetObjectId(), columnsGetSwizzled(), columnsIsValid(), columnsOdbcToCollection(), columnsSet(), columnsSetObject(), columnsSetObjectId()
property formalParameters as list of %SQL.StatementParameter;
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.
Property methods: formalParametersBuildValueArray(), formalParametersCollectionToDisplay(), formalParametersCollectionToOdbc(), formalParametersDisplayToCollection(), formalParametersGet(), formalParametersGetObject(), formalParametersGetObjectId(), formalParametersGetSwizzled(), formalParametersIsValid(), formalParametersOdbcToCollection(), formalParametersSet(), formalParametersSetObject(), formalParametersSetObjectId()
property interface as %Integer;
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)
Property methods: interfaceDisplayToLogical(), interfaceGet(), interfaceIsValid(), interfaceLogicalToDisplay(), interfaceNormalize(), interfaceSet()
property objects as list of %SQL.StatementObject;
A collection of StatementObject objects representing the columns that are object values.
Property methods: objectsBuildValueArray(), objectsCollectionToDisplay(), objectsCollectionToOdbc(), objectsDisplayToCollection(), objectsGet(), objectsGetObject(), objectsGetObjectId(), objectsGetSwizzled(), objectsIsValid(), objectsOdbcToCollection(), objectsSet(), objectsSetObject(), objectsSetObjectId()
property parameterCount as %Integer;
The number of parameters defined in this statement. This is the same as parameters.Count().
Property methods: parameterCountDisplayToLogical(), parameterCountGet(), parameterCountIsValid(), parameterCountLogicalToDisplay(), parameterCountNormalize(), parameterCountSet()
property parameters as list of %SQL.StatementParameter;
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.
Property methods: parametersBuildValueArray(), parametersCollectionToDisplay(), parametersCollectionToOdbc(), parametersDisplayToCollection(), parametersGet(), parametersGetObject(), parametersGetObjectId(), parametersGetSwizzled(), parametersIsValid(), parametersOdbcToCollection(), parametersSet(), parametersSetObject(), parametersSetObjectId()
property statementType as %Integer;

Integer value indicating the type of statement.

1SELECT
2INSERT (also 'INSERT OR UPDATE')
3UPDATE
4DELETE
5COMMIT
6ROLLBACK
7GRANT
8REVOKE
9CREATE TABLE
10ALTER TABLE
11DROP TABLE
12CREATE VIEW
13ALTER VIEW
14DROP VIEW
15CREATE INDEX
16ALTER INDEX (Not supported)
17DROP INDEX
18CREATE ROLE
19DROP ROLE
20SET TRANSACTION
21START TRANSACTION
22%INTRANSACTION
23%BEGTRANS (Alias for START TRANSACTION)
24%INTRANS (Alias for %INTRANSACTION)
25GET (Not supported)
26SET OPTION
27STATISTICS (UPDATE STATISTICS, not supported))
28%CHECKPRIV
29CREATE USER
30ALTER USER
31DROP USER
32%CHECKPRIV (SQL Admin Privilege)
33GRANT (SQL Admin Privilege)
34REVOKE (SQL Admin Privilege)
35CREATE FUNCTION
36CREATE METHOD
37CREATE PROCEDURE
38CREATE QUERY
39DROP FUNCTION
40DROP METHOD
41DROP PROCEDURE
42DROP QUERY
43CREATE TRIGGER
44DROP TRIGGER
45CALL
46SAVEPOINT
47LOCK TABLE
48UNLOCK TABLE
49CREATE DATABASE
50DROP DATABASE
51USE DATABASE
52TUNE TABLE
53DECLARE
54CREATE MODEL
55DROP MODEL
56TRAIN MODEL
57ALTER MODEL
58VALIDATE MODEL
59SET ML CONFIGURATION
60CREATE ML CONFIGURATION
61ALTER ML CONFIGURATION
62DROP ML CONFIGURATION
63FREEZE PLANS
64UNFREEZE PLANS
65PURGE
66BUILD INDEX
67CREATE AGGREGATE
68DROP AGGREGATE
69LOAD
70CREATE SCHEMA
71DROP SCHEMA
72CREATE SERVER
73ALTER SERVER
74DROP SERVER
75CREATE FOREIGN TABLE
76ALTER FOREIGN TABLE
77DROP FOREIGN TABLE
78CANCEL QUERY
79EXPLAIN
99Anything not list above
Property methods: statementTypeDisplayToLogical(), statementTypeGet(), statementTypeIsValid(), statementTypeLogicalToDisplay(), statementTypeNormalize(), statementTypeSet()

Methods

method %Display() as %Status
Display metadata on the current device.
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 13) IsList 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
method printMetadata(pMetadata As %RawString) as %Status

Inherited Members

Inherited Methods

FeedbackOpens in a new tab