connect | connect |
createConnectionDetails | createConnectionDetails |
createZipFile | Compress files and/or folders into a single zip file |
DatabaseConnectorDriver | Create a DatabaseConnectorDriver object |
dbAppendTable-method | Insert rows into a table |
dbClearResult-method | Clear a result set |
dbColumnInfo-method | Information about result types |
dbConnect-method | Create a connection to a DBMS |
dbCreateTable-method | Create a table in the database |
dbDisconnect-method | Disconnect (close) a connection |
dbExecute-method | Execute an update statement, query number of rows affected, and then close result set |
dbExistsTable-method | Does a table exist? |
dbFetch-method | Fetch records from a previously executed query |
dbGetQuery-method | Send query, retrieve results and then clear result set |
dbGetRowCount-method | The number of rows fetched so far |
dbGetRowsAffected-method | The number of rows affected |
dbGetStatement-method | Get the statement associated with a result set |
dbHasCompleted-method | Completion status |
dbIsValid-method | Is this DBMS object still valid? |
dbIsValid-method | Is this DBMS object still valid? |
dbListFields-method | List field names of a remote table |
dbListTables-method | List remote tables |
dbQuoteIdentifier-method | Quote identifiers |
dbQuoteString-method | Quote literal strings |
dbReadTable-method | Copy data frames from database tables |
dbRemoveTable-method | Remove a table from the database |
dbSendQuery-method | Execute a query on a given database connection |
dbSendQuery-method | Execute a query on a given database connection |
dbSendStatement-method | Execute a data manipulation statement on a given database connection |
dbUnloadDriver-method | Load and unload database drivers |
dbWriteTable-method | 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-method | Show an Object |
show-method | Show an Object |