R Database Interface


[Up] [Top]

Documentation for package ‘DBI’ version 0.2-5

Help Pages

dbCallProc Call an SQL stored procedure
dbClearResult Execute a statement on a given database connection
dbColumnInfo Database interface meta-data
dbCommit DBMS Transaction Management
dbConnect Create a connection to a DBMS
dbDataType Determine the SQL Data Type of an S object
dbDataType-method Determine the SQL Data Type of an S object
dbDataType.default Determine the SQL Data Type of an S object
dbDisconnect Create a connection to a DBMS
dbDriver Database Interface (DBI) Classes and drivers
dbDriver-method Database Interface (DBI) Classes and drivers
dbExistsTable Convenience functions for Importing/Exporting DBMS tables
dbGetDBIVersion Database interface meta-data
dbGetException Execute a statement on a given database connection
dbGetInfo Database interface meta-data
dbGetQuery Execute a statement on a given database connection
dbGetRowCount Database interface meta-data
dbGetRowsAffected Database interface meta-data
dbGetStatement Database interface meta-data
dbHasCompleted 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.
dbListFields 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.
dbListTables List items from a remote DBMS and from objects that implement the database interface DBI.
dbReadTable Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable Convenience functions for Importing/Exporting DBMS tables
dbRollback DBMS Transaction Management
dbSendQuery Execute a statement on a given database connection
dbSetDataMappings Set data mappings between an DBMS and R/Splus
dbUnloadDriver Database Interface (DBI) Classes and drivers
dbWriteTable Convenience functions for Importing/Exporting DBMS tables
fetch Fetch records from a previously executed query
format Support functions
isSQLKeyword Make R/Splus identifiers into legal SQL identifiers
isSQLKeyword-method Make R/Splus identifiers into legal SQL identifiers
make.db.names Make R/Splus identifiers into legal SQL identifiers
make.db.names-method Make R/Splus identifiers into legal SQL identifiers
print Support functions
print.list.pairs Support functions
SQLKeywords Make R/Splus identifiers into legal SQL identifiers
SQLKeywords-method Make R/Splus identifiers into legal SQL identifiers
summary Support functions
summary-method Class DBIDriver