Open topic with navigation
A pseudo table generated for internal debugging purposes only. This table does not provide much information for users. It contains information about a client connection's open statements (as opposed to
SYSTEM.LOCALSTATEMENTS - see LOCALSTATEMENTS System Table Description - which provides information about all open statements local to the transaction engine to which the client is currently connected).
Caution: Client applications should never contain code that accesses
SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.
|HANDLE||integer||An identifier, unique only to the specific connection, that represents the executing statement.
|REFCOUNT||integer||Internal reference count.|
|OPENRESULTSETS||boolean||True if the statement has open result sets and false otherwise.|
|COMPILEDREFCOUNT||integer||Internal reference count.|
|SQLSTRING||string||The statement's SQL string.|
Parameter string — A string representing the parameters specified in the query. The string representing each parameter is of the format:
Each parameter string is separated by a space. For example:
NUMPARAM PARAMS --------- ---------------------------- 2 0/string/'hello' 1/integer/