similar to: Inserting Date Field into Oracle table using ROracle

Hi, first thanks to Sunny Ho (and David James for the pointer) for resolving the problem of the empty rows returned from ROracle. However, I have a problem still: > library(ROracle) > ora <- dbDriver("Oracle") > con <- dbConnect(ora, user = USER, password = PWD, dbname = DBNAME) > rs <- dbExecStatement(con, "select * from USER_TABLES") Error in

Dear List, What is the way in R to plot a graph having date time (e.g. format 12/31/2002 13:12) in the x axis and numerical value (e.g. temperature) on the Y-axis ? I could not get 'plot()' to do this as X axis values are non-numeric. 'bwplot()' sorts the date values and thereby changes the order of the dates and of Y. The date/time values have to be shown on the X-axis as tick

R-help list, I ported some R code from MS Windows PC to sun-solaris. Both do queries on the same MySQL database. PC version of R is 1.6.1 and solaris version is 1.6.0. I use RMySQL_0.5-0 (on solaris) and RODBC 1.0-1 on PC to connect to MySQL. The PC version took about 65 mins. to run wheras the Solaris (SunOS 5.7) version took 375 mins. (> 6 hrs). R and RMySQL are resident on the same host

I am trying to compute the periodicity of a time series. I would like to know which function in R does it. Also, how do I plot a Enright / Chi-square periodogram using R ? ( Enright, J.T., 1965, Journal of Theoret. Biol. 8,426-468) Greatly appreciate your help. Thanks in advance, Sukhaswami Malladi *************************************************************************** The contents

R-help, Could someone in the list write as to what is the R function to perform repeated measures ANOVA and post-hoc tests ? Thanks in advance, swami *************************************************************************** The contents of this communication are intended only for the addressee and may contain confidential and/or privileged material. If you are not the intended recipient,

Colleagues During the transition to R3.0.0 (OS X), one of the packages that I used -- SASxport -- did not work until I used the "type=source" option in install.packages. This led to an adventure: 1. I downloaded the package source: SASxport_1.2.4.tar.gz 2. in the SASxport/R folder, I found all the functions that are part of the package. I became interested in whether I could

Happy New Year to all in the list! I am trying to issue an SQL query to a database from R using RODBC (on Windows). The data source file is on my PC hard disk : C:\Program Files\ODBC\sql.dsn The "\" character does not get interpreted properly in R - it is removed from the file-spec string or if I specify "\\" it appears as such with a syntax error in odbcConnect(dsn,

All When I read data into an R variable x using RODBC command: x <- sqlQuery(channel,"select a, b from tabl",as="data frame") and view x, I get 3 columns the first one being the index of the rows in x. What options do I use in sqlQuery so as not have the index in x ? How do I get rid of the index otherwise. For some functions like princomp (and boxplot) for

Dear R-help, I was trying to convert a date and time record extracted from a fortran subroutine I worte and I encounter some problem. The data read in time and date in a format like "2000-05-11_01:00:00.0000" in fortran output. It is in GMT. I need to convert it to CST (GMT+8). I did the following steps. > cdate [1] "2000-05-11_01:00:00.0000\005\003" # I am not sure

Hello everybody, I found that queries (send by "dbExecStatement" ) with more than 4000 characters length produces an error in ROracle (ver 0.3-3). Maybe there is a limitation of 4kB.... Is this a bug? If yes, is this problem solved in the latest version of ROracle (ver 0.5-0)? My system information: platform sparc-sun-solaris2.8 arch sparc os solaris2.8

Dear list-members, I have observed quite a strange problem with the date package. You will find below what I get on my machine (Ubuntu). I have been able to reproduce the error on Red Hat too. But it seems not to happen on Windows (and on some other Linux distros?). > require(date) Loading required package: date > sessionInfo() R version 2.15.2 (2012-10-26) Platform: x86_64-pc-linux-gnu

Hi, I have some confusion in applying a function over a column. Here's my function. I just need to shift non-March month-ends to March month-ends. Initially I tried seq.dates, but one cannot give a negative increment (decrement) here. return(as.Date(seq.dates(format(xdate,"%m/%d/%Y"),by="months",len=4)[4]) ) Hence this simple function: > mydate <-

I have a large dataset organised in choice groups see below. Each choice represents a separate occasion with 1 product chosen out of the 6 offered.            +-------------------------------------------------------------------------------------------------+      | dn   obs   choice      acid   br                 date       cdate   situat~n   mth   year   set |     

Hey folks, I have a problem with the definition of a variable of type slist in CFEngine on # uname -a ; cat /etc/redhat-release Linux policyhub.example.com 3.10.0-693.el7.x86_64 #1 SMP Tue Aug 22 21:09:27 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux CentOS Linux release 7.4.1708 (Core) I'm not sure if its valid to ask CFEngine questions on this mailing list, but as far as I'm running on

Hi all!! I would like to know if anyone has experienced this behaviour with ROracle package. I'm attaching information to reproduce the issue. Bug maybe? Thank you very much for your attention. Ramon. ################################################################## ################################################################## oraExecStatement BUG : RS-DBI driver: (ORA-02005:

Hi all, I've been playing with ROracle (0.5-9) for a few days and I can't wrap my mind around this one. Here's a sample of my R (2.4.0) session. my.df<-data.frame(prd_id=c(123,456),vol_factor=c(.123,.456)) > my.df prd_id vol_factor 1 123 0.123 2 456 0.456 > library(ROracle) Loading required package: DBI >

An update to the ROracle package is now in CRAN. Version 0.5-0 * This version has an experimental dynamic SQL binding to data frames. SQL statements can be "prepared" (parsed and cached for improved performance), and columns of data frames bound to them for automatic data transfer). For details see the help() for "Oracle", "dbPrepareStatement" and

i can manage the MySQL queries into active record.but in some cases basically with sub-queries.i didn''t get the correct output. here when i trying to change the MySQL queries into active-record. *MySQL Query* *select count(*) from ( SELECT transactions.loyalty_id FROM transactions JOIN loyalties ON (transactions.loyalty_id = loyalties.id) where loyalties.created_at >

I'm beginner with R language My goal is to write a function that takes an input Erlang entering your ? Name ? Name ? Date of birth. The program will calculate age and display output first I do know the system date (month, day, year) I find with Sys.Date () I found a function. net to calculate the age Protected Sub calcul_age() Dim datetimenow = DateTime.Now Dim

Dear List, Would anyone know how to perform prepared queries with ROBC ? I had a shot with some of the internal (non-exported) functions of the package but ended up with a segfault, so I prefer asking around before experimenting further... Thanks, Laurent