[R] SQL and system
Thomas W Blackwell
tblackw at umich.edu
Tue Apr 1 17:05:50 CEST 2003
Does the greater than sign in the isql.tcl command need to quoted
in some way to protect it from being interpreted by the shell ?
(That's just a guess. I don't understand why there's an R question
- tom blackwell - u michigan medical school - ann arbor -
(all the quotes in Julien's message below seem to have been trashed
by switching from one encoding to another - sorry.)
On Tue, 1 Apr 2003, Julien Dinh wrote:
> Hi All,
> Im using system commands in R to send requests to my database.
> CMD=paste(isql.tcl \ select xxxx from yyyyy where zzzzz = 501 \)
> This works perfectly fine, but if I want to be able to add dates
> In command line it would be
> isql.tcl select xxxx from yyyyy where zzzzz = 501 and date>20021020
> Does somebody has an idea how to translate this into R code?
> Thank you for your time,
> Julien Dinh
More information about the R-help