| sqlCopy {RODBC} | R Documentation |
Functions to copy tables or result sets from one database to another.
sqlCopy(channel, query, destination, destchannel = channel,
verbose = FALSE, errors = TRUE, ...)
sqlCopyTable(channel, srctable, desttable, destchannel = channel,
verbose = FALSE, errors = TRUE)
channel, destchannel |
connection handle as returned by
odbcConnect. |
query |
any valid SQL statement |
destination, srctable, desttable |
character: a database table name accessible from the connected dsn. |
verbose |
Display statements as they are sent to the server? |
errors |
if TRUE halt and display error, else return -1. |
... |
additional arguments to be passed to sqlSave. |
sqlCopy as is like sqlQuery,
but saves the output of query in table destination on
channel destchannel.
sqlCopyTable
copies the structure of srctable to desttable on dsn
destchannel. This is within the limitations of the ODBC lowest
common denominator. More precise control is possible via
sqlQuery.
See sqlGetResults.
Michael Lapsley and Brian Ripley
## Not run:
## example for a l/casing DBMS
sqlSave(channel, USArrests, rownames = "state")
query <- paste("select state, murder from usarrests",
"where rape > 30", "order by murder")
sqlCopy(channel, query, "HighRape", rownames = FALSE)
sqlFetch(channel, "HighRape", rownames = "state", max = 5)
sqlDrop(channel, "HighRape")
## End(Not run)