OPENRESULTS System Table Description

Description

A pseudo table, generated to present information about a connection that is currently executing and returning a result set back to the client.

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.

Fields

Field Name Type Description
CONNID integer A unique identifier for the connection.
HANDLE integer An identifier, unique only to the specific connection, that represents the executing statement.
ROWCOUNT bigint The total number of rows currently returned to the client.
LOBSTREAMBYTES bigint The total number of lob stream bytes currently returned to the client.
TOTALBYTES bigint The total number of bytes currently returned to the client.
CREATEDTIMESTAMP timestamp The timestamp for when this result set was created.
FETCHCOUNT bigint The total count of fetches performed to return rows to the client.

Indexes

None