All functions

connect

connect

createConnectionDetails

createConnectionDetails

createZipFile()

Compress files and/or folders into a single zip file

DatabaseConnectorDriver()

Create a DatabaseConnectorDriver object

dbAppendTable(<DatabaseConnectorConnection>,<character>,<data.frame>)

Insert rows into a table

dbClearResult(<DatabaseConnectorResult>)

Clear a result set

dbColumnInfo(<DatabaseConnectorResult>)

Information about result types

dbConnect(<DatabaseConnectorDriver>)

Create a connection to a DBMS

dbCreateTable(<DatabaseConnectorConnection>,<character>,<data.frame>)

Create a table in the database

dbDisconnect(<DatabaseConnectorConnection>)

Disconnect (close) a connection

dbExecute(<DatabaseConnectorConnection>,<character>)

Execute an update statement, query number of rows affected, and then close result set

dbExistsTable(<DatabaseConnectorConnection>,<character>)

Does a table exist?

dbFetch(<DatabaseConnectorResult>)

Fetch records from a previously executed query

dbGetQuery(<DatabaseConnectorConnection>,<character>)

Send query, retrieve results and then clear result set

dbGetRowCount(<DatabaseConnectorResult>)

The number of rows fetched so far

dbGetRowsAffected(<DatabaseConnectorResult>)

The number of rows affected

dbGetStatement(<DatabaseConnectorResult>)

Get the statement associated with a result set

dbHasCompleted(<DatabaseConnectorResult>)

Completion status

dbIsValid(<DatabaseConnectorDbiConnection>)

Is this DBMS object still valid?

dbIsValid(<DatabaseConnectorJdbcConnection>)

Is this DBMS object still valid?

dbListFields(<DatabaseConnectorConnection>,<character>)

List field names of a remote table

dbListTables(<DatabaseConnectorConnection>)

List remote tables

dbQuoteIdentifier(<DatabaseConnectorConnection>,<character>)

Quote identifiers

dbQuoteString(<DatabaseConnectorConnection>,<character>)

Quote literal strings

dbReadTable(<DatabaseConnectorConnection>,<character>)

Copy data frames from database tables

dbRemoveTable(<DatabaseConnectorConnection>,<character>)

Remove a table from the database

dbSendQuery(<DatabaseConnectorDbiConnection>,<character>)

Execute a query on a given database connection

dbSendQuery(<DatabaseConnectorJdbcConnection>,<character>)

Execute a query on a given database connection

dbSendStatement(<DatabaseConnectorConnection>,<character>)

Execute a data manipulation statement on a given database connection

dbUnloadDriver(<DatabaseConnectorDriver>)

Load and unload database drivers

dbWriteTable(<DatabaseConnectorConnection>,<character>,<data.frame>)

Copy data frames to database tables

disconnect()

Disconnect from the server

executeSql()

Execute SQL code

getTableNames()

List all tables in a database schema.

insertTable()

Insert a table on the server

isSqlReservedWord()

Test a character vector of SQL names for SQL reserved words

jdbcDrivers

How to download and use JDBC drivers for the various data platforms.

lowLevelExecuteSql()

Execute SQL code

lowLevelQuerySql()

Low level function for retrieving data to a data frame

lowLevelQuerySqlToAndromeda()

Low level function for retrieving data to a local Andromeda database

querySql()

Retrieve data to a data.frame

querySqlToAndromeda()

Retrieves data to a local Andromeda database

renderTranslateExecuteSql()

Render, translate, execute SQL code

renderTranslateQuerySql()

Render, translate, and query to data.frame

renderTranslateQuerySqlToAndromeda()

Render, translate, and query to local Andromeda

show(<DatabaseConnectorConnection>)

Show an Object

show(<DatabaseConnectorDriver>)

Show an Object