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.