Usage Note 19205: Specifying Oracle Comments/Hints Using SAS/ACCESS® Interface to
Oracle
Oracle Hints/Comments can be specified, using SAS/ACCESS Interface to Oracle - Proc SQL PassThrough facility.
The Oracle Hint/Comment is specified 'as is' using the comment syntax show here:
/* comment or hint goes here */
|
The following information and example are from the 9.1.3 SAS OnlineDoc:
In this example, the PRESERVE_COMMENTS argument is specified after the USER= and PASSWORD= arguments.
The Oracle SQL query is enclosed in the required parentheses.
The SQL INDX command identifies the index for the Oracle query optimizer to use in processing the query.
Note that multiple hints are separated with blanks.
proc sql;
connect to oracle as mycon(user=testuser
password=testpass preserve_comments);
select *
from connection to mycon
(select /*+indx(empid) all_rows */
count(*) from employees);
quit;
|
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Oracle | Microsoft Windows XP Professional | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |
Microsoft Windows NT Workstation | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
Microsoft Windows 2000 Server | 9.1 TS1M3 | |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
*
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: | Usage Note |
Priority: | low |
Topic: | SAS Reference ==> Procedures ==> ACCESS
|
Date Modified: | 2008-05-05 09:32:36 |
Date Created: | 2006-12-19 09:26:49 |