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=’ASTER DB2 GREENPLUM NETEZZA ORACLE TERADATA’.
    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 nCluster 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
Copyright © SAS Institute Inc. All rights reserved.