Format Publishing with User-Defined Functions and the SAS Embedded Process

There are two methods by which format publishing is processed inside the database:
  • user-defined functions
    Formats are converted by the publishing macros into format functions that are similar to any user-defined functions in the database.
    In-database processing of formats by means of user-defined functions is supported by DB2 under UNIX, Greenplum, Netezza, and Teradata.
  • SAS Embedded Process
    The SAS Embedded Process is a SAS server process that is installed and runs inside the database to read and write data from the database. The advantage of using the SAS Embedded Process is that a single function or a stored procedure is used instead of multiple, user-defined functions.
    Format publishing using the SAS Embedded Process is supported for Aster, DB2, Greenplum, Netezza, and Teradata.
    The SAS Embedded Process is one of the deployed components for in-database processing. For more information, see the SAS In-Database Products: Administrator's Guide.
Copyright © SAS Institute Inc. All rights reserved.