QueryRAM: A function to send SQL queries to the RAM legacy stock...

Description Usage Arguments Details Examples

Description

A function to send SQL queries to the RAM legacy stock assessment database

Usage

1
QueryRAM(query, con.drv = NULL)

Arguments

query

a valid SQL query executable against RAM Legacy DB

con.drv

a list containing a non-expired connection to and driver for RAM legacy DB

Details

Runs SQL query against srdb (RAM Legacy DB) and returns result before using be sure to read the fair use policy: http://ramlegacy.marinebiodiversity.ca/ram-legacy-stock-assessment-database/ram-legacy-stock-assessment-database-fair-use-policy

Examples

1
2
3
4
5
6
7
## Not run: 
## make a connection
c <- ConnectRAM()  #running without argumetns requires RAM.auth list set as global option
lme.df<-QueryRAM("select * from srdb.lmerefs", c)
CloseRAM(c)

## End(Not run)

ashander/RAMlegacyr documentation built on May 12, 2019, 4:41 a.m.