sqlSave64: sqlSave64

In familyforestresearchcenter/nwos: An R Package for Working with USDA Forest Service, National Woodland Owner Survey Data

sqlSave64

Description

Wrapper function for RODBC:sqlSave to save data to the NWOS database from a 64-bit R session

Usage

sqlSave64(data, tname, vtypes)

Arguments

data	is a dataframe containing records to be loaded to the NWOS DB
tname	is a string containing the table to which the data should be appended
vtypes	is a vector containing the oracle datatype associated with columns in data

Details

This function must be run on a machine with an ODBC connection (32-bit) to the USFS FIA production database through a user with read permissions.

Value

a dataframe containing the return from the SQL query

Examples

sqlSave64(data=df,tname='FS_NWOS.CODES_UPDATE',vtypes=c(CREATED_DATE="Date"))

familyforestresearchcenter/nwos documentation built on April 12, 2025, 11:54 a.m.