Skip to main content

Prepared statements

System views for querying active prepared statements information in the user session.

These views are available from release Jun2020 (11.37.7) onwards.

sys.prepared_statements
name type references description
"sessionid" INTEGER sys.sessions.sessionid The internal session identifier.
"username" VARCHAR sys.users.name The user who created the prepared statement.
"statementid" INTEGER   The internal prepared statement identifier. This value must be used to execute the prepared statement.
"statement" VARCHAR   The original SQL prepare statement.
"created" TIMESTAMP   Creation date and time of the prepared statement.

 

sys.prepared_statements_args
name type references description
"statementid" INTEGER sys.prepared_statements.statementid The internal prepared statement identifier.
"type" VARCHAR sys.types.sqlname The SQL type name.
"type_digits" INTEGER   The number of digits (radix 2) for numeric types or max length for character/binary strings.
"type_scale" INTEGER   The precision after decimal point. Only applicable for decimal/numeric types.
"inout" TINYINT   Whether the argument is an input (=1) argument or an output(=0) result column.
"number" INTEGER   The argument position starting from 0. First the output result columns are listed next the input parameters.
"schema" VARCHAR   The schema name of an output argument.
"table" VARCHAR   The table name of an output argument.
"column" VARCHAR   The column name of an output argument.