dbSendQuery: dbSendQuery

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

dbSendQuery

Description

dbSendQuery

Usage

## S4 method for signature 'EXAConnection,character'
dbSendQuery(
  conn,
  statement,
  schema = "",
  profile = TRUE,
  default_fetch_rec = 100,
  ...
)

Arguments

conn	A valid EXAConnection
statement	vector mode character : an SQL statement to be executed in EXASOL db
schema	vector mode character : a focus schema. This must have write access for the result set to be temporarily stored. If the user has only read permission on the schema to be read, another schema may be entered here, and table identifiers in stmt parameter must be fully qualified (schema.table).
profile	logical, default TRUE : collect profiling information
default_fetch_rec	numeric, default 100 :
...	unused.

Value

EXAResult object which can be used for fetching rows. It also contains metadata.

Methods (by class)

• conn = EXAConnection,statement = character: Sends an SQL statement to an EXASOL DB, prepares for result fetching.

Author(s)

EXASOL AG <[e-mail]>

See Also

DBI::dbSendQuery()

Other EXAConnection related objects: EXAConnection-class, dbBegin,EXAConnection-method, dbCommit,EXAConnection-method, dbConnect,EXADriver-method, dbCurrentSchema(), dbEnd(), dbExistsTable,EXAConnection,character-method, dbGetQuery,EXAConnection,character-method, dbListFields,EXAConnection,character-method, dbListTables,EXAConnection-method, dbReadTable,EXAConnection,character-method, dbRemoveTable,EXAConnection,character-method, dbRollback,EXAConnection-method, dbWriteTable,EXAConnection,character,data.frame-method

Other DQL functions: dbClearResult,EXAResult-method, dbExistsTable,EXAConnection,character-method, dbGetQuery,EXAConnection,character-method, dbListFields,EXAConnection,character-method, dbListTables,EXAConnection-method, dbReadTable,EXAConnection,character-method, fetch,EXAResult,numeric-method

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