Displaying 1 result from an estimated 1 matches for "syagprd1".
2012 Jul 30
1
why querying Sybase IQ using RODBC returns error ?
...iq.sg.csfb.com;port=3051}"
chan <- odbcDriverConnect(connstr)
on.exit(odbcClose(chan))
if (length(list(...)) > 0)
sql <- sprintf(sql, ...)
x <- sqlQuery(chan, sql, as.is = as.is)
return(x)
}
R>
R>
R>
R> x <- sybaseiq.query("select * from syagprd1.orders where
tradedate='120727' and acct='DVW'")
Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max, buffsize,
:
negative length vectors are not allowed
R> x
[1] "42000 -131 [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'order'...