dim.odbcDataset: Size of odbcDataset Object

In dfdb.RODBC: Access Data Tables in an RODBC Data Base as Pseudo-Dataframes

Description

Returns the number of rows and columns in the database table corresponding to the odbcDataset object

Usage

## S3 method for class 'odbcDataset'
dim(x)

Arguments

x	an odbcDataset object.

Value

The number of rows and columns in the odbcDataset object.

Author(s)

John Fox

See Also

odbcDataset, odbcDriverConnect, Prestige.

Examples

## This example presupposes that the data set prestige is stored as a table
## in the database attached via odbcDriverConnect().
## This data set is supplied as the data frame Prestige in the dfdb.RODBC
## package.
## Depending upon your OS/DBMS, the call to odbcDriverConnect() may have
## to be modified.

## Not run: 
channel <- odbcDriverConnect()
            
sqlTables(channel)

Prestige <- odbcDataset(channel, "prestige")  # create a pseudo-dataframe
Prestige
dim(Prestige)
  
## End(Not run)

dfdb.RODBC documentation built on May 2, 2019, 5:18 p.m.