R Graphical Manual

Last data update: 2014.03.03

Data Source

R Release (3.2.3)
CranContrib
BioConductor
All

Data Type

Packages
Functions
Images
Data set

Classification

Results 1 - 9 of 9 found.
[1] < 1 > [1] Sort:

get_server_details (Package: RSQLServer) : Get server details from YAML file

The sql.yaml file in a user's HOME directory can store server details and login credentials (in plaintext). This works around the instability associated with jTDS's single-sign on functionality. The YAML file format is documented in this package's README file, while an example is provided in extdata/sql.yaml (see example). At a high level, each server should be documented in its own associative array with each aspect of the server documented in an associative array.

● Data Source: CranContrib
● Keywords: internal
● Alias: get_server_details
● 0 images

SQLServerResult-class (Package: RSQLServer) : An S4 class to represent a SQL Server result set

Extends the JDBCResult class.

● Data Source: CranContrib
● Keywords: internal
● Alias: SQLServerResult-class, dbColumnInfo,SQLServerResult-method, dbFetch,SQLServerResult,numeric-method, dbGetInfo,SQLServerResult-method, dbHasCompleted,SQLServerResult-method, dbIsValid,SQLServerResult-method, fetch,SQLServerResult,numeric-method
● 0 images

have_test_server (Package: RSQLServer) : Checks availability of TEST server

SQL Server details can be specified in a ~/sql.yaml file. To be able to run examples and some tests in the package, it is necessary for there to be a valid server with name TEST in this file.

● Data Source: CranContrib
● Keywords:
● Alias: have_test_server
● 0 images

setops (Package: RSQLServer) : Intersect and setdiff methods

Customised intersect and setdiff methods for the dplyr generics (which override base package function definitions). These methods only support SQL Server 2005 and greater.

● Data Source: CranContrib
● Keywords:
● Alias: intersect, intersect.tbl_sqlserver, setdiff, setdiff.tbl_sqlserver, setops
● 0 images

SQLServer (Package: RSQLServer) : Create a SQLServer driver

This creates a SQL Server driver used to access SQL Server databases and is based on the jTDS driver.

● Data Source: CranContrib
● Keywords:
● Alias: SQLServer, dbConnect,SQLServerDriver-method
● 0 images

src_sqlserver (Package: RSQLServer) : Connect to SQLServer or Sybase

Use src_sqlserver to connect to an existing SQL Server or Sybase database, and tbl to connect to tables within that database.

● Data Source: CranContrib
● Keywords:
● Alias: src_sqlserver
● 0 images

SQLServerDriver-class (Package: RSQLServer) : An S4 class to represent a SQL Server driver

Extends the JDBCDriver class and uses jTDS driver.

● Data Source: CranContrib
● Keywords: internal
● Alias: SQLServerDriver-class, dbGetInfo,SQLServerDriver-method, show,SQLServerDriver-method
● 0 images

SQLServerConnection-class (Package: RSQLServer) : An S4 class to represent a SQL Server connection

Extends the JDBCConnection class.

● Data Source: CranContrib
● Keywords: internal
● Alias: SQLServerConnection-class, dbDataType,SQLServerConnection-method, dbExistsTable,SQLServerConnection-method, dbGetInfo,SQLServerConnection-method, dbIsValid,SQLServerConnection-method, dbListTables,SQLServerConnection-method, dbSendQuery,SQLServerConnection,character-method, dbSendUpdate,SQLServerConnection,character-method, dbWriteTable,SQLServerConnection-method, show,SQLServerConnection-method
● 0 images

RSQLServer (Package: RSQLServer) : RSQLServer

Wrapper around RJDBC DBI applied specifically to SQL Server. Sybase may work, but to date hasn't been tested. You will need the Java Runtime Environment.

● Data Source: CranContrib
● Keywords:
● Alias: RSQLServer, RSQLServer-package
● 0 images