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.

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 true, disk spill was used.

Indexes

None