Displaying 2 results from an estimated 2 matches for "sqldata".
Did you mean:
sqdata
2010 Feb 16
1
RODBC missing values in integer columns
...d
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
[[alternat...
2010 Jul 02
2
unable to get bigglm working, ATTN: Thomas Lumley
...skip=0, header=FALSE,...);
if (nrow(rval)==0) {
close(conn);
conn<<-NULL;
rval<-NULL;
} else {
rval$relage <- rval$loctime/rval$term;
};
return(rval);
}
}
};
a <- make.data ( filename = "G:/sqldata/newf4.csv", chunksize = 100000,
colClasses = list ("NULL", "Date","Date", "integer",
"factor",rep("numeric",5),rep("integer",2)),
col.names = c("id","dt", "promdt","term", "...