Displaying 5 results from an estimated 5 matches for "sqlcopy".
2008 Nov 25
1
Error in sqlCopy in RODBC
Hi All,
I am trying to copy portions of tables from one SQL database to another,
using sqlCopy in the RODBC package.
RemoteChannel = connection to remote database
LocalChannel = connection to local database
LocalTable = table in my local database to receive data from the remote
database
query <- select query in SQL
sqlCopy(RemoteChannel, query, "LocalTable", destchannel=Local...
1999 Oct 16
1
ODBC database access package
...el commands based on the concept of moving data
between dataframes and sql tables with a single command as much as
possible. For example sqlSave(0,dataframe) will save the dataframe
to a table of the same name, creating or modifying it as necessary.
All of the functions _SEEM_ to work except one (sqlCopy), where I
cannot resolve a problem with propagating substitute()ed names down a
function tree. This is only a convenience function and is not strictly
necessary. The rest seem to work OK, but I would appreciate any suggestions
for improved robustness, bug fixes, or improvements.
I need a volunt...
1999 Oct 04
1
SQL-Interface
Can anyone give advice how to interactively exchange data between R and
SQL-Databases like DB2, ORACLE, MS-SQL-Server ?
If the answer is: 'currently not', this would be information for me as well.
I will summarize to the list.
Best regards
--
Dr. Jens Oehlschl?gel-Akiyoshi
MD FACTORY GmbH
Bayerstrasse 21
80335 M?nchen
Tel.: 089 545 28-27
Fax.: 089 545 28-10
http://www.mdfactory.de
2000 Mar 08
0
RODBC: follow up
...uld run into memory
trouble.
Fetching single rows using odbcFetchRow() probably creates slow looping
problems in R.
I think the interface would become more suitable for big datasets if it had
functions for writing and reading BLOCKS of rows. E.g. sqlgetresults() could
get a parameter nmax= .
(6.3) sqlCopy()
Convert query results into a data.frame before sending them to another
channel could lead to memory trouble.
Better would be a lowlevel implementation in C, which copies rowwise.
Regards
Jens
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-devel mailing list...
2009 Mar 09
5
Help
...agreement (Berwin A Turlach)
> 39. Re: Chi-Square Test Disagreement (Andrew Choens)
> 40. Problem with aovlmer.fnc in languageR (Mats Exter)
> 41. Re: S4 slot containing either aov or NULL (Matthias Kohl)
> 42. Re: Chi-Square Test Disagreement ( (Ted Harding))
> 43. Re: Error in sqlCopy in RODBC (BKMooney)
> 44. Smoothed 3D plots (Jorge Ivan Velez)
> 45. Re: weighted ftable (Andrew Choens)
> 46. Re: Chi-Square Test Disagreement (Andrew Choens)
> 47. Reshape with var as fun.aggregate (locklin.jason@gmail.com)
> 48. Creating a vector based on lookup function (PD...