

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,
+         safer = TRUE, addPK = FALSE,
+   fast = FALSE, test = FALSE, nastring = NULL)

Query: INSERT INTO "testappend_slt" ( "RECORDNO", "HEADERID", "SITE",
"TESTER", "TESTCELL", "PRODUCT", "OPERATION", "OPNUM", "PRODMODE",
"VERSION", "REVISION", "UUT", "MCTL", "OPERATOR", "STARTTIME", "ENDTIME",
"ENDSTATUS", "CREATED" ) VALUES ( 999999, 1125080002314, 13, 'nextra14
', 'cell14         ', 'Nextra Gen2    ', 'IVT Gen2
', 'T710', 'E', 'PNX10.0b  ', '1104a     ', 00023, 'FORGETIT', 'Elaine
', 1227627900, 1228685220, 'C', '12/9/2008 11:06:11    ' )
>

I don't get any error message, but when I check, the record has not been
added to the table.

This observation troubles me:  The third and fourth columns have class &
mode= character  but they are not enclosed in single quotes like the other
character columns. This also applies to the UUT column.  I notice the
values in these columns contain including only numerical digits,


Any suggestions for how to resolve are appreciated!
Sincerely,
**************** Elaine McGovern Jones ************************

 ISC Tape and DASD Storage Products
     Characterization and Failure Analysis Engineering
       Phone:  408  707 9588
       jones2@us.ibm.com




	[[alternative HTML version deleted]]


