Displaying 4 results from an estimated 4 matches for "getsqltypeinfo".
2007 Oct 17
3
R and TeraData
Hello,
Does anyone know a way to connect from R on Linux box to TeraData
server? I can use ODBC connection on Windows box, but with amount of
data I need (and prefer) to use large Linux box.
Thanks,
Vadim
2012 May 29
1
RODBC, Excel, and data truncation when writing
...esttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttest'
truncated to 255 bytes in column 'v2'
Some search of the R-Help Archives yielded a possible solution,
http://tolstoy.newcastle.edu.au/R/help/06/05/28088.html
defining the typeInfo argument...
typeInfo <- getSqlTypeInfo("EXCEL")
typeInfo$character <- "varchar(3000)"
z <- odbcConnectExcel2007("test_rodbc.xlsx",readOnly=FALSE)
sqlSave(z,d,tablename="Sheet2",rownames=FALSE,typeInfo=typeInfo)
odbcClose(z)
Error in sqlSave(z, d, tablename = "Sheet2", rownames = F...
2017 Jul 13
2
consulta por varTypes de sqlSave en RODBC
...e parrafo
*4.1 Data types when saving a data frame When sqlSave creates a table,
there is some choice as to the SQL data types used. The default is to
select the SQL data type from the R type via the typeInfo argument to
sqlSave. If this is not supplied (usual) a default mapping is looked up
using getSqlTypeInfo() or by interrogating sqlTypeInfo(). This will almost
always produce the correct mapping for numeric, integer and character
columns of up to 254 characters (or bytes). In other cases (include dates
and date-times) the desired SQL type can be specified for each column via
the argument varTypes, a na...
2017 Jul 13
2
consulta por varTypes de sqlSave en RODBC
Buen dia Javier, muchas gracias por tu ayuda y el script compartido.
Me va a servir como ayuda para seguir aprendiendo sobre RODBC pero no
encuentro una solucion para este problema puntual de poder definir el tipo
y ancho de las variables, q segun creo se hace con el argumento varTypes.
Si alguien tien algun ejemplo donde haya usado la SqlSave y VarTypes, me
sera de gran ayuda.
Abrazo a todos