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.
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 |
bigint |
A connection identifier which is unique across all connections in the database. |
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. |
SQLSTRING |
string |
The SQL statement which generated the result set |
NODEID |
integer |
A unique identifier for the node that has the result set open |
DISKSPILL |
boolean |
Indicates whether disk spill was used during the statement execution. When |