Prepared Statements
System views for querying active prepared statements information in the user session.
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. |