分享SAS连接到netezza配置流程

1 从SAS取文件，装到netezza机器
从SAS安装目录
/SASFormatsLibraryforNetezza/2.1/Netezza32bitTwinFin/ ，取文件accelnetzfmt-2.1-1_lax.sh
安装步骤
mkdir –p /nz/extensions
chmod 755 /nz/extensions
cd /nz/extensions
chmod 755 accelnetzfmt-2.1-n_lax.sh
path_to_self-extracting_tar_file/accelnetzfmt-2.1-n_lax.sh

2 执行以下宏，让宏在数据库中注册。
%indnzpj;
%let indconn=SERVER=[youIP] USER=[youUSER] PW=[youPassword] DB=[youDBNAME];
%INDNZ_PUBLISH_JAZLIB
(DATABASE=[DBNAME]
,ACTION=replace
,OUTDIR=
);
quit;

%indnzpc;
%let indconn =SERVER=[youIP] USER=[youUSER] PW=[youPassword] DB=[youDBNAME];
%INDNZ_PUBLISH_COMPILEUDF
(DATABASE=[DBNAME]
,ACTION=replace
,OUTDIR=
);
quit;

%indnzpm:
%let indconn =SERVER=[youIP] USER=[youUSER] PW=[youPassword] DB=[youDBNAME];
%INDNZ_PUBLISH_MODEL
(DIR=[you PATH]
, MODELNAME=[youMODELNAME]
, DATASTEP=score.sas
, XML=score.xml
, DATABASE=[youDBNAME];
, DBCOMPILE=[youDBNAME];
, DBJAZLIB=[youDBNAME];
, ACTION=REPLACE
, MODE=FENCED
, IDCASE=UPPERCASE
, OUTDIR=[youOUTPUTDIR]
);
quit;