LIBNAME Statement Specifics for Netezza

Overview

This section describes the LIBNAME statement that SAS/ACCESS Interface to Netezza supports and includes examples. For general information about this feature, see LIBNAME Option for Relational Databases.
Here is the LIBNAME statement syntax for accessing Netezza.
LIBNAME libref netezza <connection-options> <LIBNAME-options>;

Arguments

libref
specifies any SAS name that serves as an alias to associate SAS with a database, schema, server, or group of tables and views.
netezza
specifies the SAS/ACCESS engine name for the Netezza interface.
connection-options
provide connection information and control how SAS manages the timing and concurrence of the connection to the DBMS. When you use the LIBNAME statement, you can connect to the Netezza Performance Server in two ways. Specify only one of these methods for each connection because they are mutually exclusive.
  • SERVER=, DATABASE=, PORT=, USER=, PASSWORD=, READ_ONLY=
  • USER=, DSN=, PASSWORD=
Here is how these options are defined.
SERVER=<'>server-name<'>
specifies the server name or IP address of the Netezza Performance Server to which you want to connect. This server accesses the database that contains the tables and views that you want to access. If the server name contains spaces or nonalphanumeric characters, you must enclose it in quotation marks.
DATABASE=<'>database-name<'>
specifies the name of the database on the Netezza Performance Server that contains the tables and views that you want to access. If the database name contains spaces or nonalphanumeric characters, you must enclose it in quotation marks.
Alias: DB=
PORT=port
specifies the port number that is used to connect to the specified Netezza Performance Server. If you do not specify a port, the default is 5480.
USER=<'>Netezza-user-name<'>
specifies the Netezza user name (also called the user ID) that you use to connect to your database. If the user name contains spaces or nonalphanumeric characters, you must enclose it in quotation marks.
PASSWORD=<'>Netezza-password<'>
specifies the password that is associated with your Netezza user name. If the password contains spaces or nonalphanumeric characters, you must enclose it in quotation marks. You can also specify PASSWORD= with the PWD=, PASS=, and PW= aliases.
READ_ONLY=YES | NO
specifies whether to connect to the Netezza database in Read-Only mode (YES) or read-write (NO) mode. If you do not specify anything for READ_ONLY=, the default of NO is used. You can also specify READ_ONLY with the READONLY= alias.
DSN=<'>Netezza-data-source<'>
specifies the configured Netezza ODBC data source to which you want to connect. Use this option if you have existing Netezza ODBC data sources that are configured on your client. This method requires additional setup—either through the ODBC Administrator control panel on Windows platforms, or through the odbc.ini file or a similarly named configuration file on UNIX platforms. So it is recommended that you use this connection method only if you have existing, functioning data sources that have been defined.
LIBNAME-options
define how SAS processes DBMS objects. Some LIBNAME options can enhance performance, and others determine locking or naming behavior. The following table describes the LIBNAME options for SAS/ACCESS Interface to Netezza, with the applicable default values. For details about these options, see LIBNAME Options for Relational Databases.
SAS/ACCESS LIBNAME Options for Netezza
Option
Default Value
none
none
operation-specific
NO
NO
UNIQUE
none
1000 when inserting rows; 0 when updating rows
none
none
none
DBMS
YES
none
none
1024
NO
YES
NO
COMPAT
NO
NO
none
YES
NO
automatically calculated based on row length
0
none
none
0
none
automatically calculated based on row length
NO
none
YES
none
none
NO
NO
none
NO
NO
NO

Netezza LIBNAME Statement Examples

In this example, SERVER=, DATABASE=, USER=, and PASSWORD= are connection options.
libname mydblib netezza server=npssrv1 database=test 
   user=netusr1 password=netpwd1;

proc print data=mydblib.customers;
   where state='CA';
run;
In the next example, DSN=, USER=, and PASSWORD= are connection options. The NZSQL data source is configured in the ODBC Administrator Control Panel on Windows platforms or in the odbc.ini file or a similarly named configuration file on UNIX platforms.
libname mydblib netezza dsn=NZSQL 
   user=netusr1 password=netpwd1;

proc print data=mydblib.customers;
   where state='CA';
run;