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:
Messages like the following will be written to the log:
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 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#018476A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#018476| Type: | Problem Note |
| Priority: | medium |
| Topic: | SAS Reference ==> LIBNAME Engines Third Party ==> Information Exchange ==> ODBC (Open Database Connectivity) |
| Date Modified: | 2008-06-30 10:35:48 |
| Date Created: | 2006-09-11 14:44:51 |