To publish scoring model
functions and the SAS_PUT( ) function on a DB2 server, the
publishing macros perform the following tasks:
-
Create and transfer the files to
the DB2 environment.
-
Compile those source files into
object files using the appropriate compiler for that system.
-
Link with the SAS formats library.
After that, the publishing macros register the format
and scoring model functions in DB2 with those object files. If an
existing format or scoring model function is replaced, the publishing
macros remove the obsolete object file upon successful compilation
and publication of the new format or scoring model functions.
The publishing macros
use a SAS FILENAME SFTP statement to transfer the format or scoring
source files to the DB2 server. An SFTP statement offers a secure
method of user validation and data transfer. The SAS FILENAME SFTP
statement dynamically launches an SFTP or PSFTP executable, which
creates an SSH client process that creates a secure connection to
an OpenSSH Server. All conversation across this connection is encrypted,
from user authentication to the data transfers.
Currently, only the
OpenSSH client and server on UNIX that supports protocol level SSH-2
and the PUTTY client on WINDOWS are supported. For more information
about setting up the SSH software to enable the SAS SFTP to work,
please see Setting Up SSH Client Software in UNIX and Windows
Environments for Use with the SFTP Access Method in SAS 9.2, SAS 9.3,
and SAS 9.4, located at http://support.sas.com/techsup/technote/ts800.pdf.
Note: This process is valid only
when using publishing formats and scoring functions. It is not applicable
to the SAS Embedded Process. If you use the SAS Embedded Process,
the scoring publishing macro creates the scoring files and uses the
SAS/ACCESS Interface to DB2 to insert the scoring files into a model
table.