Select Your Region
Americas
Europe
Middle East & Africa
Asia Pacific
SUPPORT / SAMPLES & SAS NOTES
Problem Note 18476: READBUFF setting not honored with certain SQL queries against a SAS/ACCESS® Interface to ODBC libref
 |  |  |  |  |
Due to internal processing, SAS/ACCESS Interface to ODBC can not always perform buffered reads with PROC SQL queries. No errors will be generated but performance can decrease.
Buffered read is enabled with the READBUFF option which can be specified with the LIBNAME statement or as a DATA set option.
Queries containing ORDER BY and GROUP BY fall into the category.
The SASTRACE option can be used to check how many rows are read into SAS per fetch operation:
options sastrace=',,,s a' sastraceloc=saslog nostsuffix;
Messages like the following will be written to the log:
ODBC: Fetch time in seconds for 1 row is 0.000005
The message indicates that one row is read at a time, i.e. buffered read is disabled.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to ODBC | 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Linux | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| HP-UX IPF | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||