R Database Interface


[Package List] [Top]

Documentation for package `DBI' version 0.1-9

User Guides and Package Vignettes

Read overview or browse directory.

Help Pages

D F I M P S

-- D --

dbCallProc Call an SQL stored procedure
dbCallProc,DBIConnection-method Call an SQL stored procedure
dbCallProc-methods Call an SQL stored procedure
dbClearResult Execute a statement on a given database connection
dbClearResult,DBIResult-method Execute a statement on a given database connection
dbClearResult-methods Execute a statement on a given database connection
dbColumnInfo Database interface meta-data
dbColumnInfo,DBIResult-method Database interface meta-data
dbColumnInfo-methods Database interface meta-data
dbCommit DBMS Transaction Management
dbCommit,DBIConnection-method DBMS Transaction Management
dbCommit-methods DBMS Transaction Management
dbConnect Create a connection to a DBMS
dbConnect,DBIDriver-method Create a connection to a DBMS
dbConnect-methods Create a connection to a DBMS
dbDataType Determine the SQL Data Type of an S object
dbDataType,DBIObject-method Determine the SQL Data Type of an S object
dbDataType-methods Determine the SQL Data Type of an S object
dbDisconnect Create a connection to a DBMS
dbDisconnect,DBIConnection-method Create a connection to a DBMS
dbDisconnect-methods Create a connection to a DBMS
dbDriver Database Interface (DBI) Classes and drivers
dbDriver,character-method Database Interface (DBI) Classes and drivers
dbDriver-methods Database Interface (DBI) Classes and drivers
dbExistsTable Convenience functions for Importing/Exporting DBMS tables
dbExistsTable,DBIConnection,character-method Convenience functions for Importing/Exporting DBMS tables
dbExistsTable-methods Convenience functions for Importing/Exporting DBMS tables
dbGetDBIVersion Database interface meta-data
dbGetDBIVersion,-method Database interface meta-data
dbGetDBIVersion-methods Database interface meta-data
dbGetException Execute a statement on a given database connection
dbGetException,DBIConnection-method Execute a statement on a given database connection
dbGetException-methods Execute a statement on a given database connection
dbGetInfo Database interface meta-data
dbGetInfo,DBIObject-method Database interface meta-data
dbGetInfo-methods Database interface meta-data
dbGetQuery Execute a statement on a given database connection
dbGetQuery,DBIConnection,character-method Execute a statement on a given database connection
dbGetQuery-methods Execute a statement on a given database connection
dbGetRowCount Database interface meta-data
dbGetRowCount,DBIResult-method Database interface meta-data
dbGetRowCount-methods Database interface meta-data
dbGetRowsAffected Database interface meta-data
dbGetRowsAffected,DBIResult-method Database interface meta-data
dbGetRowsAffected-methods Database interface meta-data
dbGetStatement Database interface meta-data
dbGetStatement,DBIResult-method Database interface meta-data
dbGetStatement-methods Database interface meta-data
dbHasCompleted Database interface meta-data
dbHasCompleted,DBIResult-method Database interface meta-data
dbHasCompleted-methods Database interface meta-data
DBIConnection-class Class DBIConnection
DBIDriver-class Class DBIDriver
DBIObject-class Class DBIObject
DBIResult-class Class DBIResult
dbListConnections List items from a remote DBMS and from objects that implement the database interface DBI.
dbListConnections,DBIDriver-method List items from a remote DBMS and from objects that implement the database interface DBI.
dbListConnections-methods List items from a remote DBMS and from objects that implement the database interface DBI.
dbListFields List items from a remote DBMS and from objects that implement the database interface DBI.
dbListFields,DBIConnection,character-method List items from a remote DBMS and from objects that implement the database interface DBI.
dbListFields-methods List items from a remote DBMS and from objects that implement the database interface DBI.
dbListResults List items from a remote DBMS and from objects that implement the database interface DBI.
dbListResults,DBIConnection-method List items from a remote DBMS and from objects that implement the database interface DBI.
dbListResults-methods List items from a remote DBMS and from objects that implement the database interface DBI.
dbListTables List items from a remote DBMS and from objects that implement the database interface DBI.
dbListTables,DBIConnection-method List items from a remote DBMS and from objects that implement the database interface DBI.
dbListTables-methods List items from a remote DBMS and from objects that implement the database interface DBI.
dbReadTable Convenience functions for Importing/Exporting DBMS tables
dbReadTable,DBIConnection,character-method Convenience functions for Importing/Exporting DBMS tables
dbReadTable-methods Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable,DBIConnection,character-method Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable-methods Convenience functions for Importing/Exporting DBMS tables
dbRollback DBMS Transaction Management
dbRollback,DBIConnection-method DBMS Transaction Management
dbRollback-methods DBMS Transaction Management
dbSendQuery Execute a statement on a given database connection
dbSendQuery,DBIConnection,character-method Execute a statement on a given database connection
dbSendQuery-methods Execute a statement on a given database connection
dbSetDataMappings Set data mappings between an DBMS and R/S-Plus
dbSetDataMappings,DBIResult,data.frame-method Set data mappings between an DBMS and R/S-Plus
dbSetDataMappings-methods Set data mappings between an DBMS and R/S-Plus
dbUnloadDriver Database Interface (DBI) Classes and drivers
dbUnloadDriver,DBIDriver-method Database Interface (DBI) Classes and drivers
dbUnloadDriver-methods Database Interface (DBI) Classes and drivers
dbWriteTable Convenience functions for Importing/Exporting DBMS tables
dbWriteTable,DBIConnection,character,data.frame-method Convenience functions for Importing/Exporting DBMS tables
dbWriteTable-methods Convenience functions for Importing/Exporting DBMS tables

-- F --

fetch Fetch records from a previously executed query
fetch,DBIResult,numeric-method Fetch records from a previously executed query
fetch-methods Fetch records from a previously executed query
format Support functions

-- I --

isSQLKeyword Make R/S-Plus identifiers into legal SQL identifiers
isSQLKeyword,DBIObject,character-method Make R/S-Plus identifiers into legal SQL identifiers
isSQLKeyword-methods Make R/S-Plus identifiers into legal SQL identifiers

-- M --

make.db.names Make R/S-Plus identifiers into legal SQL identifiers
make.db.names,DBIObject,character-method Make R/S-Plus identifiers into legal SQL identifiers
make.db.names-methods Make R/S-Plus identifiers into legal SQL identifiers

-- P --

print Support functions
print.list.pairs Support functions

-- S --

SQLKeywords Make R/S-Plus identifiers into legal SQL identifiers
SQLKeywords,DBIObject-method Make R/S-Plus identifiers into legal SQL identifiers
SQLKeywords,missing-method Make R/S-Plus identifiers into legal SQL identifiers
SQLKeywords-methods Make R/S-Plus identifiers into legal SQL identifiers
summary Support functions
summary,DBIObject-method Summarize a DBI object
summary-methods Summarize a DBI object