Man pages for DatabaseConnector
Connecting to Various Database Platforms

connectconnect
createConnectionDetailscreateConnectionDetails
createZipFileCompress files and/or folders into a single zip file
DatabaseConnectorConnection-classDatabaseConnectorConnection class.
DatabaseConnectorDbiConnection-classDatabaseConnectorDbiConnection class.
DatabaseConnectorDriverCreate a DatabaseConnectorDriver object
DatabaseConnectorDriver-classDatabaseConnectorDriver class.
DatabaseConnectorJdbcConnection-classDatabaseConnectorJdbcConnection class.
DatabaseConnector-packageDatabaseConnector: Connecting to Various Database Platforms
DatabaseConnectorResult-classDatabaseConnector results class.
dbAppendTable-DatabaseConnectorConnection-character-data.frame-methodInsert rows into a table
dbClearResult-DatabaseConnectorResult-methodClear a result set
dbColumnInfo-DatabaseConnectorResult-methodInformation about result types
dbConnect-DatabaseConnectorDriver-methodCreate a connection to a DBMS
dbCreateTable-DatabaseConnectorConnection-character-data.frame-methodCreate a table in the database
dbDisconnect-DatabaseConnectorConnection-methodDisconnect (close) a connection
dbExecute-DatabaseConnectorConnection-character-methodExecute an update statement, query number of rows affected,...
dbExistsTable-DatabaseConnectorConnection-character-methodDoes a table exist?
dbFetch-DatabaseConnectorResult-methodFetch records from a previously executed query
dbGetQuery-DatabaseConnectorConnection-character-methodSend query, retrieve results and then clear result set
dbGetRowCount-DatabaseConnectorResult-methodThe number of rows fetched so far
dbGetRowsAffected-DatabaseConnectorResult-methodThe number of rows affected
dbGetStatement-DatabaseConnectorResult-methodGet the statement associated with a result set
dbHasCompleted-DatabaseConnectorResult-methodCompletion status
dbIsValid-DatabaseConnectorDbiConnection-methodIs this DBMS object still valid?
dbIsValid-DatabaseConnectorJdbcConnection-methodIs this DBMS object still valid?
dbListFields-DatabaseConnectorConnection-character-methodList field names of a remote table
dbListTables-DatabaseConnectorConnection-methodList remote tables
dbQuoteIdentifier-DatabaseConnectorConnection-character-methodQuote identifiers
dbQuoteString-DatabaseConnectorConnection-character-methodQuote literal strings
dbReadTable-DatabaseConnectorConnection-character-methodCopy data frames from database tables
dbRemoveTable-DatabaseConnectorConnection-character-methodRemove a table from the database
dbSendQuery-DatabaseConnectorDbiConnection-character-methodExecute a query on a given database connection
dbSendQuery-DatabaseConnectorJdbcConnection-character-methodExecute a query on a given database connection
dbSendStatement-DatabaseConnectorConnection-character-methodExecute a data manipulation statement on a given database...
dbUnloadDriver-DatabaseConnectorDriver-methodLoad and unload database drivers
dbWriteTable-DatabaseConnectorConnection-character-data.frame-methodCopy data frames to database tables
disconnectDisconnect from the server
downloadJdbcDriversDownload DatabaseConnector JDBC Jar files
executeSqlExecute SQL code
getAvailableJavaHeapSpaceGet available Java heap space
getTableNamesList all tables in a database schema.
insertTableInsert a table on the server
isSqlReservedWordTest a character vector of SQL names for SQL reserved words
jdbcDriversHow to download and use JDBC drivers for the various data...
lowLevelExecuteSqlExecute SQL code
lowLevelQuerySqlLow level function for retrieving data to a data frame
lowLevelQuerySqlToAndromedaLow level function for retrieving data to a local Andromeda...
querySqlRetrieve data to a data.frame
querySqlToAndromedaRetrieves data to a local Andromeda database
renderTranslateExecuteSqlRender, translate, execute SQL code
renderTranslateQueryApplyBatchedRender, translate, and perform process to batches of data.
renderTranslateQuerySqlRender, translate, and query to data.frame
renderTranslateQuerySqlToAndromedaRender, translate, and query to local Andromeda
show-DatabaseConnectorConnection-methodShow an Object
show-DatabaseConnectorDriver-methodShow an Object
DatabaseConnector documentation built on Nov. 18, 2021, 5:08 p.m.