[R] Variables in RODBC environment

[Thorsten Muehge]

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);