Overview of In-Database Procedures

Running In-Database Procedures

To run in-database procedures, these actions must be taken:

The SQLGENERATION system option or the SQLGENERATION LIBNAME option must be set to DBMS.

The SQLGENERATION system option or LIBNAME statement option controls whether and how in-database procedures are run inside the database. By default, the SQLGENERATION system option is set to NONE and the in-database procedures are run using conventional SAS processing, not inside the database.

Conventional SAS processing is also used when specific procedure statements and options do not support in-database processing. For complete information, see the SQLGENERATION= System Option or SQLGENERATION= LIBNAME Option.
The LIBNAME statement must point to a valid version of the DBMSs:
- Teradata server running version 12 or above for Linux
- DB2 UDB9.5 Fixpack 3 running only on AIX or Linus x64
- Oracle 9i
.