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.