Thanks for the reply - thru R i have large data sets in oracle, mssql, postgres and we have jdbc drivers for all of them - most of these systems are on UNIX/LINUX and ODBC is not used - we use JDBC to hit the DB's usually in java applications we have. other than that we are a large SAS shop and i am trying to find an alternative to SAS, i think R has a good chance.
For R and SQL - i assume using the wrapper below is the easiest way to hit databases via SQL - are there any other ways i am missing? or is JDBC route the easiest when ODBC is not available? not sure if R contains some standard database routines that i am not seeing? also does R have some good data manipulations function - if so, could you point me in the right direction (similiar to DATA steps in SAS) -thx! -----Original Message----- From: Prof Brian Ripley [mailto:[EMAIL PROTECTED] Sent: Saturday, October 23, 2004 3:03 AM To: zubin Cc: [EMAIL PROTECTED] Subject: Re: [R] JDBC DB access in R The J is for Java (I presume, you did't actually say), and R is written in C. So `all' you need to do is to call a Java wrapper from R and call JDBC from that. I believe it has been done via RSJava. But if all you want to do is to retrieve a dataframe, isn't this rather hard work? On Fri, 22 Oct 2004, zubin wrote: > Hello, i see packages referencing using ODBC access to databases via R, are > there any packages that use JDBC to submit SQL to a database and return into > a data frame? -- Brian D. Ripley, [EMAIL PROTECTED] Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595 ______________________________________________ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html