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 |
DatabaseConnectorDbiResult-class | DatabaseConnector DBI results class. |
DatabaseConnectorDriver | Create a DatabaseConnectorDriver object |
DatabaseConnectorDriver-class | DatabaseConnectorDriver class. |
DatabaseConnectorJdbcResult-class | DatabaseConnector JDBC results class. |
DatabaseConnector-package | DatabaseConnector: Connecting to Various Database Platforms |
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-method | Insert rows into a table |
dbClearResult-DatabaseConnectorDbiResult-method | Clear a result set |
dbClearResult-DatabaseConnectorJdbcResult-method | Clear a result set |
dbColumnInfo-DatabaseConnectorDbiResult-method | Information about result types |
dbColumnInfo-DatabaseConnectorJdbcResult-method | Information about result types |
dbConnect-DatabaseConnectorDriver-method | Create a connection to a DBMS |
dbCreateTable-DatabaseConnectorConnection-method | Create a table in the database |
dbDisconnect-DatabaseConnectorConnection-method | Disconnect (close) a connection |
dbExecute-DatabaseConnectorConnection-character-method | Execute an update statement, query number of rows affected,... |
dbExistsTable-DatabaseConnectorConnection-character-method | Does a table exist? |
dbFetch-DatabaseConnectorDbiResult-method | Fetch records from a previously executed query |
dbFetch-DatabaseConnectorJdbcResult-method | Fetch records from a previously executed query |
dbGetInfo-DatabaseConnectorConnection-method | Get DBMS metadata |
dbGetInfo-DatabaseConnectorDriver-method | Get DBMS metadata |
dbGetQuery-DatabaseConnectorConnection-character-method | Send query, retrieve results and then clear result set |
dbGetRowCount-DatabaseConnectorDbiResult-method | The number of rows fetched so far |
dbGetRowCount-DatabaseConnectorJdbcResult-method | The number of rows fetched so far |
dbGetRowsAffected-DatabaseConnectorDbiResult-method | The number of rows affected |
dbGetRowsAffected-DatabaseConnectorJdbcResult-method | The number of rows affected |
dbGetStatement-DatabaseConnectorDbiResult-method | Get the statement associated with a result set |
dbGetStatement-DatabaseConnectorJdbcResult-method | Get the statement associated with a result set |
dbHasCompleted-DatabaseConnectorDbiResult-method | Completion status |
dbHasCompleted-DatabaseConnectorJdbcResult-method | Completion status |
dbIsValid-DatabaseConnectorDbiConnection-method | Is this DBMS object still valid? |
dbIsValid-DatabaseConnectorJdbcConnection-method | Is this DBMS object still valid? |
dbListFields-DatabaseConnectorConnection-character-method | List field names of a remote table |
dbListTables-DatabaseConnectorConnection-method | List remote tables |
dbms | Get the database platform from a connection |
dbReadTable-DatabaseConnectorConnection-character-method | Copy data frames from database tables |
dbRemoveTable-DatabaseConnectorConnection-ANY-method | Remove a table from the database |
dbSendQuery-DatabaseConnectorDbiConnection-character-method | Execute a query on a given database connection |
dbSendQuery-DatabaseConnectorJdbcConnection-character-method | Execute a query on a given database connection |
dbSendStatement-DatabaseConnectorConnection-character-method | Execute a data manipulation statement on a given database... |
dbUnloadDriver-DatabaseConnectorDriver-method | Load and unload database drivers |
dbWriteTable-DatabaseConnectorConnection-ANY-method | 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... |
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... |
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 |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.