search for: iqdatabase

...e. 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&...