Low level function for retrieving data to a local Andromeda database
This is the equivalent of the querySqlToAndromeda function, except no error report is
written when an error occurs.
lowLevelQuerySqlToAndromeda(
connection,
query,
andromeda,
andromedaTableName,
datesAsString = FALSE,
integer64AsNumeric = getOption("databaseConnectorInteger64AsNumeric", default = TRUE)
)connection |
The connection to the database server. |
query |
The SQL statement to retrieve the data |
andromeda |
An open connection to a Andromeda database, for example as created using |
andromedaTableName |
The name of the table in the local Andromeda database where the results of the query will be stored. |
datesAsString |
Should dates be imported as character vectors, our should they be converted to R's date format? |
integer64AsNumeric |
Logical: should 64-bit integers be converted to numeric (double) values? If FALSE
64-bit integers will be represented using |
Retrieves data from the database server and stores it in a local Andromeda database This allows very large data sets to be retrieved without running out of memory. Null values in the database are converted to NA values in R. If a table with the same name already exists in the local Andromeda database it is replaced.
Invisibly returns the andromeda. The Andromeda database will have a table added with the query results.
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.