ORHINTS= Table Option

Specifies Oracle hints to pass to Oracle from FedSQL.

Valid in:	DELETE statement, INSERT statement, SELECT statement, UPDATE statement
Category:	Data control
Data source:	Oracle

Syntax

Arguments

Details

Example

Syntax

ORHINTS='/* Oracle-hint */'

Arguments

Oracle-hint

specifies an Oracle hint for the FedSQL language processor to pass to the DBMS as part of a query. If you do not specify a hint, FedSQL does not send any hints to Oracle. For more information, see SAS Federation Server: Administrator’s Guide.

Details

The ORHINTS= table option is used in conjunction with the DRIVER_TRACE= and DRIVER_TRACEFILE= data source connection options. PROC FEDSQL and PROC DS2 do not support use of data source connection options.

Example: Using the ORHINTS= Option

These examples show how to specify ORHINTS=:

select * from test{options orhints='/* dummy hint */'} ;

update test{options orhints='/* dummy hint */'}  set c1=1;

insert into test{options orhints='/* dummy hint */'}  values (100);

delete from test{options orhints='/* dummy hint */'} ;