Displaying 1 result from an estimated 1 matches for "sratg".
Did you mean:
srat
2009 Jul 30
0
RODBC and Oracle
....seq_no = tmzip.seq_no)
where is_test = '%d' and is_pos = '%d' and ora_hash(txn.seq_no,%d,%d)=0"
dbConn = odbcConnect("mysid",uid="myuser",pwd="mypass",case="toupper",believeNRows=FALSE)
tfg = sqlQuery(dbConn, sprintf(sqlTxnFvs,0,0,1/sratg-1,seeds[i]))
dbErr = odbcGetErrMsg(dbConn)
All of the tables except mddsg100bp are IOT tables (index organized tables aka clustered index in MSSQL).
I set the believeNRows=FALSE.
I tried increasing the ODBC DSN config buffer from the default 64k to first 5M and then 10M.
I started with columns f...