similar to: R and databases (Oracle)

Dear R-users, I was able to make ROracle package to connect to the DB (Oracle91, 64bit, on Solaris). But after executing siple SQL query, "fetch" commaned gives me an empty dataframe. ### RORACLE INSTALATION PROCEDURE ### R CMD INSTALL --configure-args='--enable-extralibs' --enable-oracle32=no ~/tmp/ROracle_0.5-5.tar.gz #since we have 64bit Oracle9i instalation PROBLEM:

Dear R-users, In order to use ROracle (v. 0.5-5) package I compiled R-1.9.1 on Linux (2.4.20-28.9smp) and installed it. I need to use Oracle9i on Solaris. When executing "library(ROracle)" I got the following error message: > library(ROracle) Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library

Sorry for posting the second time, I corrected the SQL code: PROBLEM: after executing simple statement, from within R, "fetch" function gives me the empty dataframe: ### CONNECTION, and SQL QUERY EXECUTION > ora <- dbDriver("Oracle") > con <- dbConnect(ora, "rado/only2admin" > dbListTables(con) character(0) > rs <- dbSendQuery(con,

Dear R-users Sorry for posting the previous message too soon before I have finished it. I have matrix (mprecip) with headers: > dim(mprecip) [1] 6268 170 > mprecip date GilzeRijen Eindhoven Volkel ZuidLimburg Arcen Ubachsberg 1 01/01/1978 NA 0.0 NA 0.1 NA NA 2 01/02/1978 NA 0.0 NA 0.0 NA NA 3

Dear R users, I have to include typical UNIX formated R commands and outputs into the article using LaTeX. What is the easiest way to include R prompt commands and text outputs (including messages) into LaTeX documents? Is there any template or library? So far I'm trying to produce R commands in LaTeX using LaTeX general format options. Thanks, Rado

Dear R users, I'm coming back to R after while. I have a data frame with 200 columns, each column has a name. How to extract all columns to a new dataset, but the specified (by names) ones? I was playing with that for a little bit using the vector syntax but got several syntax errors. Thanks, Rado

Dear R-users, I need to standardize residuals using standard deviation. Is the 'stdres' the proper function? Beside other methods (for standardization and normalization), are there some approaches how to standardize using standard deviation? Here is the sample of my residuals: Zres040 Zres0820 Sres040 Sres0820 PCres040 -2.101740 -2.0682900 1.6328500 0.5046730

Hi R-users, How can I found the number of a distinct values in a data frame (occurrence of distinct values)? The dataframe consists of several thousands integer numbers. Thanks, Rado -- Radoslav Bonk M.S. Dept. of Physical Geography and Geoecology Faculty of Sciences, Comenius University Mlynska Dolina 842 15, Bratislava, SLOVAKIA tel: +421 905 968 127 e-mail: rbonk at host.sk

Hello R-users, Is there any more sophisticated way how to identify the dataset outliers other then seeing them in boxplot? I wanna exclude them from further analysis and I am interested in their position in my vector data. Rado -- Radoslav Bonk M.S. Dept. of Physical Geography and Geoecology Faculty of Sciences, Comenius University Mlynska Dolina 842 15, Bratislava, SLOVAKIA tel: +421 2 602

Hi R-users, My question is more methodological one, rather than technical. I have to samples representing residuals based on two measurements techniques (resid1,resid2; n=69). I need to compare two samples, to reject one technique (the worse one), and to keep the one which gave lower residuals (better one). What to look for? What should I analyse? Means, variance, std. deviations? Based on

Hi, Does anybody know suitable documents (manuals) on writing user functions (covering loops, conditions ...) in R? Other than the usually available manuals. Thanks, Rado -- Radoslav Bonk M.S. Dept. of Physical Geography and Geoecology Faculty of Sciences, Comenius University Mlynska Dolina 842 15, Bratislava, SLOVAKIA tel: +421 905 968 127 e-mail: rbonk at host.sk

Hi R-users, I have a set of elevation residuals as geodata points. I would like to display them in the following way: -negative values using pch=20 (filled circle) -positive values using pch=1 (empty circle) while using the cex.max=5, cex.min=0.1 for points() to represent the residuals value. Basically I would like to distinguish neagtive and positive values at my map. How to do this. Thanks

Hi R-users, I am using "postscript("xx.eps", horizontal=FALSE, onefile=FALSE, height=6, width=10, pointsize=10)" and "barplot(xx.dat)" in R to produce EPS graphics for LATeX document. When checking the graphics with "gv" I see that it was not produced with full details. The main graphic is there, but axes labels and titles are missing. While checking the

Hi, I'm new to "R". I have a matrix of 6x12. I need to produce matrix of 12x6, such that rows in new matrix are columns from original matrix, and columns in a new matrix are rows from the original one. I was playing with rbind(), and cbind() with no success. Regards, -Rado -- Radoslav Bonk M.S. Dept. of Physical Geography and Geoecology Faculty of Natural Sciences, Comenius

Dear R-users, I have two outliers related questions. I. I have a vector consisting of 69 values. mean = 0.00086 SD = 0.02152 The shape of EDA graphics (boxplots, density plots) is heavily distorted due to outliers. How to define the interval for outliers exception? Is <2SD - mean + 2SD> interval a correct approach? Or should I define 95% (or 99%) limit of agreement for data interval,

Dear all... Currently I am having 5 RAC nodes with Configurations as below : 1. HW = DL580 32 Bit Processor 2. OS = RHAS 2.1 3. OCFS= Latest Version 4. RAC= Oracle9i 9.2.0.5 (32 Bit) Now I am planning to add 2 more Rac Nodes in the existing RAC: 1. HW=Itanium 64 bit processor 2. OS=RHAS 3.0 3. OCFS=Latest Version 4. RAC=Oracle9i 9.2.0.5 (32 bit) Can I

All, I am new in R. I found sqlSave() doesn't work for our Oracle9i. The following was the message: > sqlSave(channel, USArrests, rownames="state") Error in sqlColumns(channel, tablename) : USArrests : table not found on channel Check case parameter in odbcConnect > sqlQuery() works OK. Please help. Thanks. -MY

Hi experts, My customer issued debugocfs to check for file_size and extent info but values such as file_size, alloc_size, next_free_ext were 0. (/dev/sdi1 contains datafiles and arc files) # debugocfs -a 0 /dev/sdi1 debugocfs 1.0.10-PROD1 Fri Mar 5 14:35:29 PST 2004 (build fcb0206676afe0fcac47a99c90de0e7b) file_extent_0: file_number = 128 disk_offset = 1433600 curr_master = 0 file_lock =

Hi, Does anybody know how to have output from print, without the leading [1]? (Or must I use cat/write?) >out="r15" >print(out,quote=FALSE) [1] r15 And I definitely do not want the leading [1] as I want to construct a table from this. Ciao, Adolf ------------------------------------------------ Adolf Stips (new email: adolf.stips at jrc.ec.europa.eu) Global Environment

Dear Martin and Jon, I can reproduce this problem in the Windows GUI, where I observed it using Jon's program after 75 iterations. I didn't observe the problem in a Windows terminal or under RStudio, letting the program run for more than 200 iterations in each case. My system and session info: ------------- snip --------- > Sys.info() sysname release