Function reference • DatabaseConnector

All functions
`assertTempEmulationSchemaSet()`	Assert the temp emulation schema is set
`computeDataHash()`	Compute hash of data
`connect`	connect
`createConnectionDetails`	createConnectionDetails
`createDbiConnectionDetails()`	Create DBI connection details
`createZipFile()`	Compress files and/or folders into a single zip file
`DatabaseConnectorDriver()`	Create a DatabaseConnectorDriver object
`dateAdd()`	Add an interval to a date
`dateDiff()`	Compute difference between dates
`dateFromParts()`	Construct a date from parts
`day()`	Extract the day from a date
`dbAppendTable(<DatabaseConnectorConnection>,<character>)`	Insert rows into a table
`dbClearResult(<DatabaseConnectorDbiResult>)`	Clear a result set
`dbClearResult(<DatabaseConnectorJdbcResult>)`	Clear a result set
`dbColumnInfo(<DatabaseConnectorDbiResult>)`	Information about result types
`dbColumnInfo(<DatabaseConnectorJdbcResult>)`	Information about result types
`dbConnect(<DatabaseConnectorDriver>)`	Create a connection to a DBMS
`dbCreateTable(<DatabaseConnectorConnection>)`	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(<DatabaseConnectorDbiResult>)`	Fetch records from a previously executed query
`dbFetch(<DatabaseConnectorJdbcResult>)`	Fetch records from a previously executed query
`dbGetInfo(<DatabaseConnectorConnection>)`	Get DBMS metadata
`dbGetInfo(<DatabaseConnectorDriver>)`	Get DBMS metadata
`dbGetQuery(<DatabaseConnectorConnection>,<character>)`	Send query, retrieve results and then clear result set
`dbGetRowCount(<DatabaseConnectorDbiResult>)`	The number of rows fetched so far
`dbGetRowCount(<DatabaseConnectorJdbcResult>)`	The number of rows fetched so far
`dbGetRowsAffected(<DatabaseConnectorDbiResult>)`	The number of rows affected
`dbGetRowsAffected(<DatabaseConnectorJdbcResult>)`	The number of rows affected
`dbGetStatement(<DatabaseConnectorDbiResult>)`	Get the statement associated with a result set
`dbGetStatement(<DatabaseConnectorJdbcResult>)`	Get the statement associated with a result set
`dbHasCompleted(<DatabaseConnectorDbiResult>)`	Completion status
`dbHasCompleted(<DatabaseConnectorJdbcResult>)`	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
`dbms()`	Get the database platform from a connection
`dbReadTable(<DatabaseConnectorConnection>,<character>)`	Copy data frames from database tables
`dbRemoveTable(<DatabaseConnectorConnection>,<ANY>)`	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>,<ANY>)`	Copy data frames to database tables
`disconnect()`	Disconnect from the server
`downloadJdbcDrivers()`	Download DatabaseConnector JDBC Jar files
`dropEmulatedTempTables()`	Drop all emulated temp tables.
`eoMonth()`	Return the end of the month
`executeSql()`	Execute SQL code
`existsTable()`	Does the table exist?
`extractQueryTimes()`	Extract query times from a `ParallelLogger` log file
`getAvailableJavaHeapSpace()`	Get available Java heap space
`getTableNames()`	List all tables in a database schema.
`inDatabaseSchema()`	Refer to a table 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 object
`month()`	Extract the month from a date
`querySql()`	Retrieve data to a data.frame
`querySqlToAndromeda()`	Retrieves data to a local Andromeda object
`renderTranslateExecuteSql()`	Render, translate, execute SQL code
`renderTranslateQueryApplyBatched()`	Render, translate, and perform process to batches of data.
`renderTranslateQuerySql()`	Render, translate, and query to data.frame
`renderTranslateQuerySqlToAndromeda()`	Render, translate, and query to local Andromeda
`requiresTempEmulation()`	Does the DBMS require temp table emulation?
`year()`	Extract the year from a date

Reference

All functions