lowLevelQuerySql: Low level function for retrieving data to a data frame

Description Usage Arguments Details Value

View source: R/Sql.R

Description

This is the equivalent of the querySql function, except no error report is written when an error occurs.

Usage

1
2
3
4
5
6
7
lowLevelQuerySql(
  connection,
  query,
  datesAsString = FALSE,
  integerAsNumeric = getOption("databaseConnectorIntegerAsNumeric", default = TRUE),
  integer64AsNumeric = getOption("databaseConnectorInteger64AsNumeric", default = TRUE)
)

Arguments

connection

The connection to the database server.

query

The SQL statement to retrieve the data

datesAsString

Logical: Should dates be imported as character vectors, our should they be converted to R's date format?

integerAsNumeric

Logical: should 32-bit integers be converted to numeric (double) values? If FALSE 32-bit integers will be represented using R's native Integer class.

integer64AsNumeric

Logical: should 64-bit integers be converted to numeric (double) values? If FALSE 64-bit integers will be represented using bit64::integer64.

Details

Retrieves data from the database server and stores it in a data frame. Null values in the database are converted to NA values in R.

Value

A data frame containing the data retrieved from the server


DatabaseConnector documentation built on Nov. 18, 2021, 5:08 p.m.