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
`dbConnect(<DatabaseConnectorDriver>)`	Create a connection to a DBMS
`dbGetInfo(<DatabaseConnectorDriver>)`	Get DBMS metadata
`dbms()`	Get the database platform from a connection
`dbUnloadDriver(<DatabaseConnectorDriver>)`	Load and unload database drivers
`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?
`show(<DatabaseConnectorDriver>)`	Show an Object
`year()`	Extract the year from a date

Reference

All functions