SQL*Loader Processing for SAS Programs

You can improve performance for SAS Programs by directly inserting records into tables using the SQL Loader.

The following conditions are required:

• The Program must be of type SAS Program (not SAS Format or SAS Macro).

• The target tables must be of data processing type Staging, either with or without Audit.

• The target tables must also have the Target as Dataset attribute set to Yes.

• A service in a SAS service location must have the absolute path of the SQL*Loader executable in its Details field (instructions are in the Oracle Life Sciences Data Hub System Administrator's Guide).

If all these conditions are not met, the system uses conventional processing.