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