[R] using eval to handle column names in function calling scatterplot graph function

I am running R version 2.15.1 in Windows XP I am having problems with a function I'm trying to create to: 1. subset a data.frame based on function arguments (colname & parmname) 2. rename the PARMVALUE column in the data.frame based on function argument (xvar) 3. generate charts p

Re: [R] RODBC sqlSave does not append the records to a DB2 table

The query generated by R looks ok to me. I went ahead and pasted it into my DB2 Client command editor. And I got the message confirmation message. INSERT INTO STORAGE.TEST_APPEND2 ( "MACRONAME", "MACROUSER", "MACRO_RT" ) VALUES ( 's_ej_mach_config_vz', 'jones2', 5 ) DB2I The SQL command com

Re: [R] RODBC sqlSave does not append the records to a DB2 table

Hi Felipe, Thanks for your message. Your approach works for an Access database. I am trying to insert records into a table in a DB2 database on a remote AIX server. My userid has the authority to insert records, and I am able to do that using another application (DB2 Client command line). Sincerely

Re: [R] RODBC sqlSave does not append the records to a DB2 table

Hello Caveman! I am able to append records using other applications. My credentials have the authority to append. I am able to query to select records, and even delete records from the remote DB2 table using RODBC. I'm just stuck when it comes to APPEND. The DB2 database is on an AIX server, and

[R] RODBC sqlSave does not append the records to a DB2 table

I am running R version 2.9.2 on Windows XP OS with RODBC version Version: 1.3-0. Has anyone out there in the R user community successfully appended records to a DB2 table on a remote database using the sqlSave function in the RODBC package? (or by any other means from R?) I posed a similar que

[R] RODBC sqlSave does not append the records

I am running R version 2.8.1 on Windows XP OS. recs is a one-row, eighteen-column data.frame I want to insert into a DB2 table. sqlSave(channel, recs, tablename = "testappend_slt", append = TRUE, + rownames = FALSE, colnames = FALSE, + verbose = TRUE, oldstyle = FALSE, +

[R] RODBC sqlSave with DB2

I am running R version 2.8.1 on Windows XP OS. This works fine. (Data.frame dta is created with records from the DB2 table.): sql <- "select * from storage.testappend_slt order by uut" dta <- sqlQuery(channel,sql) But when I try to append records (from data.frame newdta) to the same DB2 table

[R] Can I read a file into my workspace from Rprofile.site?

I am running R version 2.8.1 on Windows XP OS. When I launch R, I would like to automatically read a file containing my database connections, user ids, and passwords into my workspace. I tried including this in my Rprofile.site file: ... local({ old <- getOption("defaultPackages") options(def

[R] Substituting in a variable file name in a Windows system command

I am running R version 2.8.1 on Windows XP OS. I generate and write a .csv file from my R script. Then the following command works to upload it to a remote server using a windows batch file that carries out the ftp (among other things). > system("C:/upload_data/uploadq8.bat C:/upload_data

[R] Can you send out an email message through Lotus Notes clients from an R script?

Can R do emailing via the Lotus Notes API like SAS can? Canyou run a script and based on results send out an email report? I just briefly looked through the packages and didn't see one that looked like it might be it, but that conclusion was based on the package names only. Is anyone using R