OPEN RESULTS 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 SQL string 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