Open topic with navigation
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.
|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.|
|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