More and more customers are accessing Netezza as a datasource in the SAS/ACCESS Interface to ODBC engine, and in order to speed up writes from SAS to Netezza, we need to implement the Netezza Remote External Tables interface, which is Netezza's version of a bulk loader, RET loader. Without this new interface, you will be unable to use the RET loader as well as be unable to create tables with double columns or update/delete any data except via PROC SQL Pass-Through.

To obtain this support, apply the hotfix.

NOTE: On Unix, you have to run with Netezza 3.1 or later to get the loads to work properly due to an incompatibility between earlier versions of Netezza and SAS/ACCESS to ODBC.

Once the HOTFIX is applied, to activate, all you have to do is add BULKLOAD=YES to the data set. This way, it will use the default named pipe interface to load data from SAS to Netezza. Other options that customers can use with Netezza:

BL_USE_PIPE=YES|NO - defaults to YES; when NO, uses a flat file (that
                     can be specified with BL_DATAFILE)

BL_DATAFILE=<path and filename> - data file that SAS will use if
                      BL_USE_PIPE=NO; not valid for USE_PIPE=YES

BL_DELETE_DATAFILE=YES|NO - defaults to YES; when NO and USE_PIPE=NO,
                      SAS will not delete the flat file we create for
the load

BL_DELIMITER='<any single character>' - Defaults to '|'; this is the
                      delimiter that SAS uses between columns in the
                      data stream; customers should set this to a
                      character that doesn't appear in their data.

BL_OPTIONS='<set of Netezza-specific options>' - Any text entered here
                      will be added to the USING clause of the Netezza
                      CREATE EXTERNAL TABLE clause that is used for the
                      bulkload.  This allows customers to specify any
                      of the external_table_options listed in the
Netezza
                      Database User's Guide.

Examples:

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :