Function reference • odbc

All functions

SUPPORTED_CONNECTION_ATTRIBUTES ConnectionAttributes: Supported Connection Attributes

show(<OdbcConnection>) dbIsValid(<OdbcConnection>) dbDisconnect(<OdbcConnection>) dbSendQuery(<OdbcConnection>,<character>) dbSendStatement(<OdbcConnection>,<character>) dbDataType(<OdbcConnection>,<ANY>) dbDataType(<OdbcConnection>,<data.frame>) dbQuoteIdentifier(<OdbcConnection>,<character>) dbQuoteIdentifier(<OdbcConnection>,<SQL>) dbRemoveTable(<OdbcConnection>,<character>) dbGetInfo(<OdbcConnection>) dbGetQuery(<OdbcConnection>,<character>) dbBegin(<OdbcConnection>) dbCommit(<OdbcConnection>) dbRollback(<OdbcConnection>) dbExistsTable(<OdbcConnection>,<Id>) dbExistsTable(<OdbcConnection>,<SQL>) dbExistsTable(<OdbcConnection>,<character>): Odbc Connection Methods

show(<OdbcDriver>) dbDataType(<OdbcDriver>,<ANY>) dbDataType(<OdbcDriver>,<list>) dbDataType(<OdbcDriver>,<data.frame>) dbIsValid(<OdbcDriver>) dbGetInfo(<OdbcDriver>): Odbc Driver Methods

dbClearResult(<OdbcResult>) dbFetch(<OdbcResult>) dbHasCompleted(<OdbcResult>) dbIsValid(<OdbcResult>) dbGetStatement(<OdbcResult>) dbColumnInfo(<OdbcResult>) dbGetRowCount(<OdbcResult>) dbGetRowsAffected(<OdbcResult>) dbBind(<OdbcResult>): Odbc Result Methods

dbConnect(<OdbcDriver>): Connect to a ODBC compatible database

dbListFields(<OdbcConnection>,<character>): List field names of a remote table

dbListTables(<OdbcConnection>): List remote tables

dbListTables-methods dbListTables,Teradata-method: ~~ Methods for Function dbListTables in Package DBI ~~

dbQuoteString-methods dbQuoteString,DBIConnection,ANY-method dbQuoteString,DBIConnection,character-method dbQuoteString,DBIConnection,SQL-method dbQuoteString,Hive,character-method: ~~ Methods for Function dbQuoteString in Package DBI ~~

: odbc: Connect to ODBC Compatible Databases (using the DBI Interface)

dbWriteTable(<OdbcConnection>,<character>,<data.frame>) dbWriteTable(<OdbcConnection>,<Id>,<data.frame>) dbWriteTable(<OdbcConnection>,<SQL>,<data.frame>) dbAppendTable(<OdbcConnection>) sqlData(<OdbcConnection>) sqlCreateTable(<OdbcConnection>): Convenience functions for reading/writing DBMS tables

odbc(): Odbc driver

odbcConnectionActions(): List the actions supported for the connection

odbcConnectionCatalogs(): odbcConnectionCatalogs

odbcConnectionColumns(): odbcConnectionColumns

odbcConnectionIcon(): Get an icon representing a connection.

odbcConnectionSchemas(): odbcConnectionSchemas

odbcConnectionTableTypes(): odbcConnectionTableTypes

odbcConnectionTables(): odbcConnectionTables

odbcDataType(): Return the corresponding ODBC data type for an R object

odbcListColumns(): List columns in an object.

odbcListDataSources(): List Available Data Source Names

odbcListDrivers(): List Available ODBC Drivers

odbcListObjectTypes(): Return the object hierarchy supported by a connection.

odbcListObjects(): List objects in a connection.

odbcPreviewObject(): Preview the data in an object.

odbcPreviewQuery odbcPreviewQuery.OdbcConnection odbcPreviewQuery.Microsoft SQL Server odbcPreviewQuery.Oracle: Create a preview query.

odbcSetTransactionIsolationLevel(): Set the Transaction Isolation Level for a Connection

sqlCreateTable-methods sqlCreateTable,DB2/AIX64-method sqlCreateTable,DBIConnection-method sqlCreateTable,HDB-method sqlCreateTable,Oracle-method sqlCreateTable,Teradata-method: ~~ Methods for Function sqlCreateTable in Package DBI ~~