To publish the SAS scoring
model functions, the SAS_PUT( ) function, and format functions
on Netezza systems, the format and scoring publishing macros perform
the following tasks:
-
Create and transfer the files,
using the Netezza External Table interface, to the Netezza server.
Using the Netezza External
Table interface, the source files are loaded from the client to a
database table through remote ODBC. The source files are then exported
to files (external table objects) on the host. Before transfer, each
source file is divided into 32K blocks and converted to hexadecimal
values to avoid problems with special characters, such as line feed
or quotation marks. After the files are exported to the host, the
source files are converted back to text.
-
Compile those
source files into object files using a Netezza compiler.
-
Link with the SAS formats library.
-
Register those object files with
the Netezza system.
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 Netezza to insert the scoring files into a
model table.