[R] Variables in RODBC environment

From: Thorsten Muehge <MUEHGE_at_de.ibm.com>
Date: Thu 05 Oct 2006 - 07:35:26 GMT

Hello Experts,
how can I use variables in the RODBC environment.

Example which does not work:

Thanks for your help.

Thorsten

pn <- '39R5238';

library(RODBC);
odbcobj <- odbcConnect("SQUIT21C",uid="muehge",pwd="xxx"); sql <- "select
u.unitid,
from test
where part in ('pn')

";
parameter <- sqlQuery(odbcobj,sql);
odbcClose(odbcobj);



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Thu Oct 05 17:38:30 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Thu 05 Oct 2006 - 10:30:08 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.