SQL and system
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 here.) - 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, I’m using system commands in R to send requests to my database. CMD=paste(“isql.tcl \’ select xxxx from yyyyy where zzzzz = 501 \’â€) Data=system(CMD,intern=T) This works perfectly fine, but if I want to be able to add dates constraints: 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