/nz/extensions/SASTKInDatabaseServerForNetezza
directory
and verify that the directory is empty.
SAS-iinstallation-directory/SASFormatsLibraryforNetezza/3.1/Netezza32bitTwinFin/
directory.
mkdir –p /nz/extensions chmod 755 /nz/extensions cd /nz/extensions chmod 755 path_to_sh_file/accelnetzfmt-3.1-n_lax.sh path_to_sh_file/accelnetzfmt-3.1-n_lax.sh
path_to_sh_file
is
the location to which you copied the self-extracting archive file
in Step 1.
/nz/extensions/SAS/SASFormatsLibraryForNetezza/3.1-n/bin/InstallAccelNetzFmt.sh /nz/extensions/SAS/SASFormatsLibraryForNetezza/3.1-n/lib/SAS_CompileUDF.o_spu10 /nz/extensions/SAS/SASFormatsLibraryForNetezza/3.1-n/lib/SAS_CompileUDF.o_x86 /nz/extensions/SAS/SASFormatsLibraryForNetezza/3.1-n/lib/libjazxfbrs_spu10.so /nz/extensions/SAS/SASFormatsLibraryForNetezza/3.1-n/lib/libjazxfbrs_x86.so
/nz/extensions/SAS/SASFormatsLibraryForNetezza/3.1
points
to the latest version.
SAS-installation-directory/SASTKInDatabaseServer/9.4/Netezza64bitTwinFin/
directory.
nzcm
commands
to install and register the SAS Embedded Process.nzcm -i SASTKInDatabaseServerForNetezza-9.4.1.n.nzc
nzcm -r SASTKInDatabaseServerForNetezza
Command
|
Action performed
|
---|---|
nzcm -help |
Displays help for NZCM
commands
|
nzcm --installed nzcm - i |
Displays the filename
(SASTKInDatabaseServerForNetezza) and the version number that is installed
|
nzcm --registered nzcm - r |
Displays the filename
(SASTKInDatabaseServerForNetezza) and the version number that is registered
|
nzcm --unregister SASTKInDatabaseServerForNetezza nzcm -u SASTKInDatabaseServerForNetezza |
Unregisters the SAS
Embedded Process
|
nzcm --unregister sas_ep nzcm -u sas_ep |
Unregisters the sas_ep
cartridge
Note: The sas_ep cartridge is installed
only once. It does not need to be unregistered or uninstalled when
the SAS Embedded Process is upgraded or reinstalled. The sas_ep cartridge
needs to be unregistered and uninstalled only when Netezza changes
the cartridge version.
|
nzcm -uninstall SASTKInDatabaseServerForNetezza nzcm -e SASTKInDatabaseServerForNetezza |
Uninstalls the SAS Embedded
Process
|
nzcm --uninstall sas_ep nzcm -e sas_ep |
Uninstalls the sas_ep
cartridge
Note: The sas_ep cartridge is installed
only once. It does not need to be unregistered or uninstalled when
the SAS Embedded Process is upgraded or reinstalled. The sas_ep cartridge
needs to be unregistered and uninstalled only when Netezza changes
the cartridge version.
|
nzcm --install SASTKInDatabaseServerForNetezza-9.4.1.n.nzc nzcm -i SASTKInDatabaseServerForNetezza-9.4.1.n.nzc |
Installs the SAS Embedded
Process
|
nzcm --install sas_ep nzcm -i sas_ep |
Installs the sas_ep
cartridge
|
nzcm --register SASTKInDatabaseServerForNetezza nzcm -r SASTKInDatabaseServerForNetezza |
Registers the SAS Embedded
Process
|
nzcm --register sas_ep nzcm -register sas_ep |
Registers the sas_ep
cartridge
|
sas_jazlib
object.
%let indconn=SERVER=yourservername USER=youruserid PW=yourpwd DB=database;
specifies the server name or IP address of the 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, enclose the server name in quotation marks.
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, enclose the user name in quotation marks.
specifies the password that is associated with your Netezza user name. If the password contains spaces or nonalphanumeric characters, enclose the password in quotation marks.
Tip | Use only PASSWORD=, PASS=, or PW= for the password argument. PWD= is not supported and causes an error. |
specifies the name of the database on the server that contains the tables and views that you want to access. If the database name contains spaces or nonalphanumeric characters, enclose the database name in quotation marks.
Interaction | The database that is specified by the %INDNZ_PUBLISH_JAZLIB macro’s DATABASE= argument takes precedence over the database that you specify in the INDCONN macro variable. If you do not specify a value for DATABASE= in either the INDCONN macro variable or the %INDNZ_PUBLISH_JAZLIB macro, the default value of SASLIB is used. For more information, see %INDNZ_PUBLISH_JAZLIB Macro Syntax. |
Tip | The object name for the SAS formats library is sas_jazlib .
|
specifies the name
of a Netezza database to which the SAS formats library is published
as the sas_jazlib
object.
Default | SASLIB |
Interaction | The database that is specified by the DATABASE= argument takes precedence over the database that you specify in the INDCONN macro variable. |
Tip | The object name for the SAS formats library is sas_jazlib .
|
specifies that the macro performs one of the following actions:
creates a new SAS formats library.
overwrites the current SAS formats library, if a SAS formats library by the same name is already registered, or creates a new SAS formats library if one is not registered.
causes the SAS formats library to be dropped from the Netezza database.
Default | CREATE |
Tip | If the SAS formats library was published previously and you specify ACTION=CREATE, you receive warning messages that the library already exists. You are prompted to use REPLACE. If you specify ACTION=DROP and the SAS formats library does not exist, you receive an error message. |
specifies a directory that contains diagnostic files.
Tip | Files that are produced include an event log that contains detailed information about the success or failure of the publishing process. |
%let indconn = server=yourserver user=youruserid password=yourpwd database=database;
specifies the server name or IP address of the 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, enclose the server name in quotation marks.
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, enclose the user name in quotation marks.
specifies the password that is associated with your Netezza user name. If the password contains spaces or nonalphanumeric characters, enclose the password in quotation marks.
Tip | Use only PASSWORD=, PASS=, or PW= for the password argument. PWD= is not supported and causes an error. |
specifies the name of the database on the server that contains the tables and views that you want to access. If the database name contains spaces or nonalphanumeric characters, enclose the database name in quotation marks.
Default | SASLIB |
Interactions | The database that is specified by the %INDNZ_PUBLISH_COMPILEUDF macro’s DATABASE= argument takes precedence over the database that you specify in the INDCONN macro variable. If you do not specify a value for DATABASE= in either the INDCONN macro variable or the %INDNZ_PUBLISH_COMPILEUDF macro, the default value of SASLIB is used. For more information, see %INDNZ_PUBLISH_COMPILEUDF Macro Syntax. |
If the SAS_COMPILEUDF function is published in a database other than SASLIB, then that database name should be used instead of SASLIB for the DBCOMPILE argument in the %INDNZ_PUBLISH_FORMATS and %INDNZ_PUBLISH_MODEL macros. Otherwise, the %INDNZ_PUBLISH_FORMATS and %INDNZ_PUBLISH_MODEL macros fail when calling the SAS_COMPILEUDF function during the publishing process. If a database name is not specified, the default is SASLIB. For documentation on the %INDNZ_PUBLISH_FORMATS and %INDNZ_PUBLISH_MODEL macros, see Documentation for Using In-Database Processing in Netezza. |
specifies the name of a Netezza database to which the SAS_COMPILEUDF is published.
Default | SASLIB |
Interaction | The database that is specified by the DATABASE= argument takes precedence over the database that you specify in the INDCONN macro variable. For more information, see INDCONN Macro Variable. |
specifies that the macro performs one of the following actions:
creates a new SAS_COMPILEUDF function.
overwrites the current SAS_COMPILEUDF function, if a SAS_COMPILEUDF function by the same name is already registered, or creates a new SAS_COMPILEUDF function if one is not registered.
causes the SAS_COMPILEUDF function to be dropped from the Netezza database.
Default | CREATE |
Tip | If the SAS_COMPILEUDF function was published previously and you specify ACTION=CREATE, you receive warning messages that the function already exists and be prompted to use REPLACE. If you specify ACTION=DROP and the SAS_COMPILEUDF function does not exist, you receive an error message. |
specifies a directory that contains diagnostic files.
Tip | Files that are produced include an event log that contains detailed information about the success or failure of the publishing process. |