Man pages for OHDSI/DatabaseConnector
Connecting to Various Database Platforms

connectconnect
createConnectionDetailscreateConnectionDetails
createZipFileCompress files and/or foldes into a single zip file
DatabaseConnectorDatabaseConnector
DatabaseConnectorConnection-classDatabaseConnectorConnection class.
DatabaseConnectorDriverCreate a DatabaseConnectorDriver object
DatabaseConnectorDriver-classDatabaseConnectorDriver class.
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-DatabaseConnectorConnection-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-DatabaseConnectorConnection-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
executeSqlExecute SQL code
getTableNamesList all tables in a database schema.
insertTableInsert a table on the server
jdbcDriversHow to download JDBC drivers for the various data platforms.
lowLevelExecuteSqlExecute SQL code
lowLevelQuerySqlLow level function for retrieving data to a data frame
lowLevelQuerySql.ffdfLow level function for retrieving data to an ffdf object
querySqlRetrieve data to a data.frame
querySql.ffdfRetrieves data to an ffdf object
show-DatabaseConnectorConnection-methodShow an Object
show-DatabaseConnectorDriver-methodShow an Object
OHDSI/DatabaseConnector documentation built on Jan. 31, 2019, 7:21 p.m.