LOCALQUERYTIMEOUTS System Table Description


A pseudo table generated to report query timeout values, as specified in Statement::setQueryTimeout() in the JDBC and C++ APIs.

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.


Field Type Description
NODEID integer The ID of the transaction engine on which the query is running
CONNECTIONID bigint A client unique ID representing the connection to the TE
QUERYTIMEOUT bigint The specified query timeout in microseconds
REMAINING bigint The remaining time for the query timeout if it has yet to be reached, in microseconds
SQL string The SQL string for the query