similar to: RODBC

Hi, I would like to install an R library from https://cran.r-project.org/src/contrib/Archive/termstrc/ I executed below code without success. Any help would be appreciated. > install.packages('/Users/termstrc_1.3.tar.gz', repos = NULL, type="source") * installing *source* package ?termstrc? ... ** using staged installation ** libs using C++ compiler: ?Apple clang

Hi, I'm trying to use the package termstrc. However I cannot figure out how to invoke helper functions like create_cashflows_matrix & create_maturities_matrix. Even when I try to invoke those with the data supplied with the package (say, corpbonds), it throws error saying "Error in as.vector(x, mode) : invalid 'mode' argument". Can anybody provide some working example

Hi, I'm trying to build the termstrc 1.1 package from its source on R 2.7.2 on Windows XP. However instead of building the package it just zips the entire source into a .tar.gz file. This is the first time I'm trying to build an R package from source. I installed the R toolset for Windows and set RTools as well as Perl & MinGW directories in the path. Anybody tried this out? Any file

I am getting segfaults when I try to read a large binary object from a SQL Server database via RODBC. I am using the FreeTDS ODBC driver, and it has been working fine when reading from this same database. I have included relevant parts of the session below. Each row of the v_MAFiles view holds a text, html or pdf version of a document. The FileType entry is one of TXT, PDF, or HTML. If

Hi Enrico, yes it works. I can also plot the graph. Next question, how do I delete the date from 16 December until 31 December 2014? Thank you very much. > dt$time <- as.POSIXct(dt$time)> > dt_ts <- xts(dt$count, dt$time)> str(dt_ts)An xts object on 2014-01-01 / 2014-12-31 23:59:00 containing: Data: integer [525600, 1] Index: POSIXct,POSIXt [525600] (TZ: "")

Hi, I'm trying to invoke the function bond_prices from termstrc package. Here is the code snippet: library(termstrc) data(eurobonds) b <- matrix(rep(c(0,0,0, 1),1),nrow=1,byrow=TRUE) group<-c("GERMANY") colnames(b) <- c("beta0","beta1","beta2","tau1") germaturities<-create_maturities_matrix(eurobonds$GERMANY)

Hi: I am using termstrc package and not sure if TODAY field (govbonds dataset) is today's date or the settlement date for the bonds. Although the name suggests that it should be today's date, but how the formula is setup indicates that it should be settlement date. Please help and thanks in advance. [[alternative HTML version deleted]]

Hi, I'm using the cubic splines from termstrc package. I invoked the splines_estim function with a group of 43 bonds. It computes 6 knot points and returns values for alpha1 to alpha7. My question is how to use these alpha1 to alpha7 in the equation of yield? For example, if I'm trying to find the yield at, say, 12.25 years, which falls between 3rd & 4th knot points what should the

Hola a todos: En la estimación de parametros de Nelson-Siegel vienen definidos 3 argumentos: rate, maturity y MidTau. Este último lo define como un vector el cual indica el término medio del vencimiento para maximizar el factor beta2.Si yo tengo un vector de maturity de 77 datos, la pregunta es:¿Qué tan importante es el argumento MidTau, y qué otra especificación tiene? no me queda muy claro cómo

I have a Postgres database that I am connecting to with the Postgres ODBC driver on Windows XP in R 2.1.0. In the database is a database with two schemas (public and X). With RODBC (1.1-4) , I can connect to the database and get the tables with sqlTables(db). I can query tables in the schema with sqlQuery("SELECT * FROM X.test"). However, I can't get the columns in table X.test

Hello all! Can someone confirm whether there is a bug or not? I was trying to use sqlUpdate in place of sqlSave as data set I import has duplications. However I get errors while using fast=FALSE argument to safely update/ignore duplicates: Error while executing the query[RODBC] ERROR: Could not SQLExecDirect 'UPDATE "data" SET "logger"=1,

Dear all, I using R version 2.9.0 on Windows XP and want to insert data from a data frame in R into a oracle database via sqlUpdate with the package RODBC. My example is the following: TEST0<-data.frame(NR=c(1,2,600),NAME=c("JK","TR","AR"), DATUM=c("2009-01-01","2010-01-02","2010-06-09")) If I create the table in the database with

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

I'm trying to insert rows of a data.frame into a database table, or update where the key fields of a record already exist in the table. I've come up with a possible solution below, but would like to hear if anyone has a better solution. # The problem demonstrated: # Create a data.frame with test values library(RODBC) tbl <- data.frame( key1 = rep(1:3, each = 2), key2 =

Buenas tardes, Estoy tratando de realizar un update en SQL desde R: sqlUpdate(conexion1, data.frame(AUXILIAR), tablename = "AUXILIAR") y me devuelve el siguiente error: *Error in sqlUpdate(conexion1, data.frame(AUXILIAR), tablename = "AUXILIAR", : * * data frame column(s) Corteoptimo Cortediario not in database table* El problema es que sí existen esas columnas en SQL pero

Is there a way to get a table in a certain schema? The Oracle database I am using has a table by the same name in two different schemas. This creates problems in sqlUpdate because to sqlUpdate there are duplicate columns. The following is part of the output of sqlColumns: sqlColumns(eids, "TEST_ARTCL_INST")[,1:4] TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME 1

Buenos días, al querer actualizar los datos de una tabla en SQL SERVER sale el siguiente error: Error in sqlUpdate(canal_conexion, Datos, tablename = "Tabla_SQL_SERVER_Actualizar", : [RODBC] Failed exec in Update22018 0 [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification Gracias desde ya por la ayuda. -- [[alternative HTML version deleted]]

Hi All, I am pretty new for RODBC. I want to save my table to a DB, so I used something like sqlSave(db, a, 'Forecast_Result', rownames = FALSE); But I got an error Error in sqlSave(db, a, "Forecast_Result", rownames = FALSE) : table 'Forecast_Result' already exists Yes, that table has been created before. But I need to overwrite the content in that

I would like to do inserts into a database table, but do updates in the fairly rare cases in which the inserts fail. I thought tryCatch might be the way to do it, but I honestly do not understand the help file for tryCatch at all. I thought something like this might work: for (i in seq(along = tbl$key)) { tryCatch(sqlSave(pg, tbl[i, ], "tbl", append = TRUE, rownames = FALSE),

Hi all: I have created a MS Access table named 'PredictedValues' through the statement below: myDB <- odbcConnectAccess("C:/Documents and Settings/Owner/Desktop/Rpond Farming.mdb",uid="admin",pwd="") sqlSave(myDB,PredictedValues,rownames=FALSE) close(myDB) But if I run the code again with new values I get the message below: Error in sqlSave(myDB,