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 or DBMS=’database-name’.
    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=’TERADATA DB2 ORACLE NETEZZA ASTER GREENPLUM’.
    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:
    • Aster 5.0 or higher
    • DB2 UDB9.5 Fixpack 7 running only on AIX or LINUX x64
    • Greenplum
    • Netezza 5.0 or higher
    • Teradata server running version 12 or higher for Linux
    • Oracle 9i