Hello,
We are having some strange issues with RODBC related to integer columns.
Whenever we do a sql query the data in a integer column is 150 actual data
points then 150 0's then 150 actual data points then 150 0's. However, our
database actually has numbers where the 0's are filled in. Furthermore,
other datatypes do not have this problem: double and varchar are correct and
do not alternate to null. Also, if we increase the rows_at_time to 1024
there are larger gaps between the 0's and actual data. The server is a
sybase IQ database. We have tested it on a different database sybase ASE and
we still get this issue.
For example :
We have the following query
sqlString = "Select ActionID, Velocity from ActionDataTable"
#where ActionID is of integer type and Velocity is of double type.
connection = odbcConnect("IQDatabase"); #this database is a sybase IQ
database
sqlData = sqlQuery(connection, sqlString);
sqlData$ActionID might be 1,2,3,4,5,6,....150, 0,0,0,0,0,0,0,....,0,0,0,
301,302,303,304,.....448,449,500,0,0,0...,0,0
and Velocity will have data values along the whole column without these big
areas of 0's.
Thanks for the help,
Robert Forler
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
