Problem Note 46849: Using the option DBINDEX=YES in an Oracle LIBNAME statement turns off in-database processing of BASE SAS® procedures
Using the LIBNAME engine with SAS/ACCESS® Interface to Oracle with one of the following procedures might result in an error:
- PROC MEANS/SUMMARY
- PROC FREQ
- PROC REPORT
- PROC TABULATE
- PROC RANK
The error, shown below, occurs when the DBINDEX=YES option is included in the LIBNAME statement. Rather than the majority of the processing being done within Oracle, SAS retrieves the rows from the table and processes the procedure itself. This might result in a performance issue.
ERROR: Requested function is not supported.
Currently, the only workaround is to remove the DBINDEX=YES option from the LIBNAME statement.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Oracle | z/OS | 9.2 TS2M3 | 9.4 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M3 | |
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M3 | |
| Microsoft® Windows® for x64 | 9.2 TS2M3 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 for x64 | 9.2 TS2M3 | |
| Microsoft Windows Server 2008 | 9.2 TS2M3 | |
| Microsoft Windows Server 2008 for x64 | 9.2 TS2M3 | 9.4 TS1M0 |
| Microsoft Windows XP Professional | 9.2 TS2M3 | |
| Windows 7 Enterprise 32 bit | 9.2 TS2M3 | |
| Windows 7 Enterprise x64 | 9.2 TS2M3 | 9.4 TS1M0 |
| Windows 7 Home Premium 32 bit | 9.2 TS2M3 | |
| Windows 7 Home Premium x64 | 9.2 TS2M3 | |
| Windows 7 Professional 32 bit | 9.2 TS2M3 | |
| Windows 7 Professional x64 | 9.2 TS2M3 | 9.4 TS1M0 |
| Windows 7 Ultimate 32 bit | 9.2 TS2M3 | |
| Windows 7 Ultimate x64 | 9.2 TS2M3 | |
| Windows Vista | 9.2 TS2M3 | |
| Windows Vista for x64 | 9.2 TS2M3 | |
| 64-bit Enabled AIX | 9.2 TS2M3 | 9.4 TS1M0 |
| 64-bit Enabled HP-UX | 9.2 TS2M3 | 9.4 TS1M0 |
| 64-bit Enabled Solaris | 9.2 TS2M3 | 9.4 TS1M0 |
| HP-UX IPF | 9.2 TS2M3 | |
| Linux | 9.2 TS2M3 | |
| Linux for x64 | 9.2 TS2M3 | 9.4 TS1M0 |
| OpenVMS on HP Integrity | 9.2 TS2M3 | |
| Solaris for x64 | 9.2 TS2M3 | 9.4 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-06-25 10:46:19 |
| Date Created: | 2012-06-20 10:00:55 |
