This section describes how to install and configure the
in-database deployment package for DB2 (SAS Formats Library for DB2
and SAS Embedded Process).
The in-database deployment
package for DB2 must be installed and configured before you can perform
the following tasks:
-
Use the %INDB2_PUBLISH_FORMATS format publishing macro to create or publish the SAS_PUT( )
function and to create or publish user-defined formats as format functions
inside the database.
-
Use the %INDB2_PUBLISH_MODEL scoring publishing macro to create scoring model functions
inside the database.
The in-database deployment
package for DB2 contains the SAS formats library and the precompiled
binary files for two additional utility functions. The package also
contains the SAS Embedded Process.
The SAS formats library
is a run-time library that is installed on your DB2 system so that
the SAS scoring model functions and the SAS_PUT( ) function
created in DB2 can access the routines within the run-time library.
The SAS formats library contains the formats that are supplied by
SAS.
The two publishing macros, %INDB2_PUBLISH_COMPILEUDF and %INDB2_PUBLISH_DELETEUDF, register
utility functions in the database. The utility functions are called
by the format and scoring publishing macros. You must run these two
macros before you run the format and scoring publishing macros.
The SAS Embedded Process
is a SAS server process that runs within DB2 to read and write data.
The SAS Embedded Process contains macros, run-time libraries, and
other software that is installed on your DB2 system so that the SAS
scoring files created in DB2 can access the routines within the SAS
Embedded Process’s run-time libraries.