similar to: RODBC sqlSave with multiple schema in DB2

Displaying 14 results from an estimated 14 matches similar to: "RODBC sqlSave with multiple schema in DB2"

2012 Jun 19
0
validation method breaks cucumber scenario
I''m trying to find an effective way to validate the following: I have 3 form fields, a select menu a checkbox and a textfield. They can all be left blank on submission, but if you select two or more it should prompt an error. If the user chooses to, only one field should be allowed to be submitted. I tried the following but it seems to be breaking my cucumber scenario. Only the first
2011 Dec 21
1
Looping over files
Hi, ?I have a list of files in one of my working directories: "chr17.chunk1.dose.fvd" "chr17.chunk1.dose.fvi" "chr17.chunk1.prob.fvd"? "chr17.chunk1.prob.fvi"? ........... ......... ........ "chr17.chunk10.dose.fvd" "chr17.chunk10.dose.fvi" "chr17.chunk10.prob.fvd" "chr17.chunk10.prob.fvi" And I am
2010 Aug 13
0
some helpful tips on using RODBC
Hey everyone, I don't have a question. Instead some helpful advice with things I've learned from trying to connect 'R' to databases using RODBC. ROBDC is a very handy tool that, once you have everything fixed up nicely, is a great way to have scripts run fairly autonomously, safe in the knowledge that data isn't accidentally messed up. But I was fairly ignorant
2004 May 10
3
sqlSave with underscores in table fieldname
Hi group, I try to write a frame to a table (RODBC). I use colnames(temp6) <- c("ind_id","ser_id","period_id","year","calc","mean") sqlSave(channel, temp6, tablename = "series_indices_test",append= TRUE, rownames=FALSE, verbose = FALSE, test = FALSE, nastring = -999999, fast = FALSE) This is giving me an error: Error in
2008 Feb 25
2
Exporting a dataframe from R to Excel
I am trying to export a dateframe created in R: > Duration_summary V1 2.5 % 97.5 % V4 2.5 % 97.5 % [1,] 1 0.46076018 1.128776 1.000000 0.5280828 0.9576338 [2,] 0 0.00000000 0.000000 1.000000 0.1741793 1.2352705 [3,] 1 0.46566719 1.313711 1.000000 0.7233312 1.4097987 [4,] 1 0.38866371 2.453226 0.976024 0.6377314 1.3493957 [5,] 1 0.08894066 1.036830
2002 Dec 31
1
RODBCType&NullDataExportProblems
Hello I am trying to move data between R and other systems (e.g. SAS and MS SQL Server) using RODBC. I think I have the most recent version of RODBC (0.9) and here is some other system info: > odbcGetInfo(channel) [1] "Microsoft SQL Server version 08.00.0679. Driver ODBC version 03.52" > version _ platform i386-pc-mingw32 arch i386 os mingw32 system i386,
2009 May 29
1
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. I get an error: sqlSave(channel, newdta, tablename = storage.testappend_slt, append
2009 Oct 16
2
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 question a few months ago and unfortunately, did not receive a response. I was hoping recent upgrades to
2009 Jun 09
0
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, + safer = TRUE, addPK = FALSE, + fast = FALSE, test = FALSE, nastring = NULL) Query:
2007 Apr 24
0
new version of seqinR
Dear useRs, The seqinR package is a library of utilities to retrieve and analyse biological sequences. A new version of seqinR, seqinR 1.0-7, has been released on CRAN. Here is a summary of changes: o A new *experimental* function extractseqs() to download sequences thru zlib compressed sockets from an ACNUC server is released. Preliminary tests suggest that working with about 100,000
2007 Apr 24
0
new version of seqinR
Dear useRs, The seqinR package is a library of utilities to retrieve and analyse biological sequences. A new version of seqinR, seqinR 1.0-7, has been released on CRAN. Here is a summary of changes: o A new *experimental* function extractseqs() to download sequences thru zlib compressed sockets from an ACNUC server is released. Preliminary tests suggest that working with about 100,000
2020 Apr 24
1
[PATCH nbdkit] golang: Pass Plugin and Connection by reference not value.
For the current set of examples this doesn't matter. This also adds another example where we use the Connection to store data, just to check that actually works. Thanks: James @ purpleidea, Dan Berrangé --- plugins/golang/nbdkit-golang-plugin.pod | 10 +- plugins/golang/Makefile.am | 9 + plugins/golang/examples/disk/disk.go | 168 ++++++++++++++++++
2006 Aug 28
0
Write signed short into a binary file (follow up and conclusion)
I've solved my problem using: (purpose: write the signed integer -19 as a two byte integer into a binary file) writeBin(as.integer(-19),myconnection, size=2) There is no need to coerce. Thanks anyway! Luca NanettiUniversity Medical Center Groningen BCN-NeuroImagingCenter A.Deusinglaan 2 9713AW Groningen The Nethterlands l dot nanetti at med dot rug dot nl
2010 Jun 25
0
WG: Samba PDC and big files
Hello, If I understand it right you want to have the same Outlook profile for the users no matter on which workstation they login? The first thing all user must have the same Version of Outlook!!!!! And use an IMAP SERVER Then you must work with prf files for outlook for eauch user in your netlogon path of samba I am working with kixstart. On sigining in each user get his pref file. You can