con4Win {SAGElyzer}R Documentation

Functions for database connection and manipulation

Description

These functions make connections to or query against a database.

Usage

con4Win(args)
con4Unix(args)
makeConnection(args)
executeQuery(sqlStat, conn, noReturn = FALSE)
query4Unix(sqlStat, conn, noReturn = FALSE)
closeConn(conn)
tableExists(conn, tableName)

Arguments

args args a list of arguments that will be used for database connection and query
sqlStat sqlStat a character string for the SQL statement to be sent to the database server
conn conn a connection object
noReturn noReturn a boolean to indicate whether a query sent to the database server will return any value
tableName tableName a character string for the name of a database table

Details

con4Win makes a connection to a database for windows.

con4Unix makes a connection to a database for unix.

makeConnection direct the effort of making a database connection depending on the platform.

executeQuery executes a SQL query statement against a database. query4Unix executes a SQL query statement against a database under unix.

closeConn closes a connection to a database.

tableExists checks to see if a given table exists in the database.

Value

con4Win returns an ODBC connection object.
con4Unix returns an Rdbi connection object.
makeConnection returns a connection object.
executeQuery returns the values for a query.
query4Unix returns the results of a query for unix.
tableExists returns TRUE if a given table exists and FALSE otherwise.

Note

The functions are part of the Bioconductor project at Dana-Farber Cancer Institute to provide Bioinformatics functionalities through R

Author(s)

Jianhua Zhang

See Also

SAGELyzer, mergeSAGE

Examples

# No examples are given as database support will be required

[Package SAGElyzer version 1.4.2 Index]