To run in-database procedures, these actions must be
taken:
-
The SQLGENERATION system option
or the SQLGENERATION LIBNAME option must be set to DBMS or DBMS=’
database-name’.
Note: By default, the SQLGENERATION
system option is “on”
for DB2, Netezza, Oracle, and Teradata.
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 DBMS=’DB2, NETEZZA ORACLE TERADATA’
and the in-database procedures are run using conventional SAS processing
for databases other than DB2, Netezza, Oracle, and Teradata. The procedures
are not run 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 the SQLGENERATION LIBNAME option in
SAS/ACCESS for Relational Databases: Reference.
-
The LIBNAME statement must point
to a valid version of the DBMSs:
-
DB2 UDB9.5 Fixpack 7 running only
on AIX or LINUX x64
-
-
Teradata server running version
12 or higher for Linux
-