Previous Page | Next Page

Data Set Options for Relational Databases

ORHINTS= Data Set Option



Specifies Oracle hints to pass to Oracle from a SAS statement or SQL procedure.
Default value: none
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: Oracle

Syntax
Syntax Description
Details
Examples

Syntax

ORHINTS='Oracle-hint'

Syntax Description

Oracle-hint

specifies an Oracle hint for SAS/ACCESS to pass to the DBMS as part of an SQL query.


Details

If you specify an Oracle hint, SAS passes the hint to Oracle. If you omit ORHINTS=, SAS does not send any hints to Oracle.


Examples

This example runs a SAS procedure on DBMS data and SAS converts the procedure to one or more SQL queries. ORHINTS= enables you to specify an Oracle hint for SAS to pass as part of the SQL query.

libname mydblib oracle user=testuser password=testpass path='myorapath';

proc print data=mydblib.payroll(orhints='/*+ ALL_ROWS */');
run;

In the next example, SAS sends the Oracle hint '/*+ ALL_ROWS */' to Oracle as part of this statement:

SELECT /*+ ALL_ROWS */ * FROM PAYROLL

Previous Page | Next Page | Top of Page