EXAResult-class: An object that is associated with a result set in an EXASOL...

In EXASOL/r-exasol: R Interface & SDK for the EXASOL Database

An object that is associated with a result set in an EXASOL Database.

Description

The result set is persisted in a DB table, which is dropped when the object is deleted in R (on garbage collection), or manually by ‘dbClearResult()’. R versions before 3.3.0 do not finalise objects on R exit, so if R is quit with an active EXAResult object, the table may stay in the DB.

Fields

connection

An EXAConnection object.

statement

A string containing the SQL query statement.

rows_fetched

An int reflecting the rows already fetched from the DB.

rows_affected

An int reflecting the length of the dataset in the DB.

is_complete

A logical indicating if the result set has been entirely fetched.

with_output

A logical indicating whether the query produced a result set.

profile

A data.frame containing profile information on the query.

columns

A data.frame containing column metadata.

temp_result_tbl

A string reflecting the name of the (temporary) table that holds the result set.

query_sent_time

A POSIXct timestamp indicating when the query was sent to the DB.

errors

A character vector containing errors.

default_fetch_rec

An int reflecting the default fetch size.

Methods

addRowsFetched(x)

Add an int (the length of a newly fetched result set) to rows_fetched.

refreshMetaData(x)

Refreshes the object's metadata.

Author(s)

EXASOL AG <[e-mail]>

See Also

DBIResult-class

Other DBI classes: EXAConnection-class, EXADriver-class, EXAObject-class

Other EXAResult related objects: dbClearResult,EXAResult-method, dbListFields,EXAConnection,character-method, fetch,EXAResult,numeric-method

EXASOL/r-exasol documentation built on Aug. 28, 2023, 2:32 a.m.