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;