LOCALQUERYTIMEOUTS System Table Description

Description

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

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.

Fields

Field Type Description

NODEID

integer

The ID of the Transaction Engine on which the query is running

CONNECTIONID

bigint

A connection identifier which is unique across all connections in the database.

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

Indexes

None