Problem Note 14208: Oracle hints not passed to the database when included in a EXECUTE
statement in PROC SQL Pass-Through and PRESERVE_COMMENTS=YES is used
The SAS option PRESERVE_COMMENTS=YES allows you to pass Oracle hints to
the database for processing. Without this option, Oracle hints are
parsed as SAS comments and are removed from the code passed to the
database.
Currently, Oracle hints are not passed when using the PROC SQL
Pass-Through EXECUTE statement. A workaround is to use the %STR macro
function to force the parser to pass the Oracle hint. For example,
execute(update %str(/)%str(*) +INDEX(name) %str(*)%str(/) class
set age=age+1 where name='Thomas') by oracle;
There is no circumvention for this
problem at the current time.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft Windows XP Professional | 8.2 TS2M0 | 9.2 TS2M0 |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | |
| Microsoft Windows 95/98 | 8.2 TS2M0 | |
| Microsoft Windows Server 2003 Standard Edition | 8.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 8.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows 2000 Server | 8.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 8.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows 2000 Datacenter Server | 8.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows 2000 Professional | 8.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 8.2 TS2M0 | 9.2 TS2M0 |
| z/OS | 8.2 TS2M0 | 9.2 TS2M0 |
| Solaris | 8.2 TS2M0 | 9.2 TS2M0 |
| 64-bit Enabled Solaris | 8.2 TS2M0 | 9.2 TS2M0 |
| Linux | 8.2 TS2M0 | 9.2 TS2M0 |
| HP-UX | 8.2 TS2M0 | 9.2 TS2M0 |
| ABI+ for Intel Architecture | 8.2 TS2M0 | 9.2 TS2M0 |
| OpenVMS Alpha | 8.2 TS2M0 | |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | 9.2 TS2M0 |
| HP-UX IPF | 9.1 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows NT Workstation | 8.2 TS2M0 | |
| 64-bit Enabled AIX | 9.1 TS1M0 | 9.2 TS2M0 |
| Tru64 UNIX | 8.2 TS2M0 | |
| AIX | 8.2 TS2M0 | 9.2 TS2M0 |
*
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 |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Oracle
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2006-02-28 08:53:53 |
| Date Created: | 2005-01-17 13:22:03 |
