Adding the Direct SQL Option to SAS Libraries

his profile allows you to add the SAS option DIRECT_SQL=NOWHERE to your SAS libraries.

TThis SAS option prevents SAS WHERE clauses and PROC SQL-generated or -specified WHERE clauses from being passed to the DBMS for processing.

The default value is null, which has the same effect as a setting of NO: the DIRECT_SQL=NOWHERE is not included in your SAS libraries.

To add the option to your SAS libraries, do the following:

1. Log in. See How to Log In to Oracle Applications Profile Forms.
2. In the Profile field, enter LSH: Include Direct SQL option to SAS library
3. Click Find.
4. In the Site column:
   • Select YES to add the SAS option DIRECT_SQL=NOWHERE to your SAS libraries
   • Select NO if you do not want to add the option to your SAS libraries
5. In the File menu, select Save and Proceed. The system displays a message that the transaction is complete.
6. Click OK. The transaction message pop-up disappears.
7. Click the X in the upper right corner of the System Profile Values window to close the window.