Tip | Use only PASSWORD=, PASS=, or PW= for the password argument. PWD= is not supported and causes an error to occur. |
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 Running the %INDNZ_PUBLISH_FORMATS Macro. |
Tip | It is not necessary that the format definitions and the SAS_PUT( ) function reside in the same database as the one that contains the data that you want to format. You can use the SQLMAPPUTO= system option to specify the database where the format definitions and the SAS_PUT( ) function have been published. |
Default | SASLIB |
See | For more information about the publishing the SAS_COMPILEUDF function, see the SAS In-Database Products: Administrator's Guide. |
Default | SASLIB |
Restriction | This argument is supported only on TwinFin systems. |
See | For more information about publishing the SAS Formats Library for Netezza, see the SAS In-Database Products: Administrator's Guide. |
Default | If you do not specify a value for FMTCAT= and you have created user-defined formats in your SAS session, the default is WORK.FORMATS. If you do not specify a value for FMTCAT= and you have not created any user-defined formats in your SAS session, only the formats that SAS supplies are available in Netezza. |
Interaction | If the format definitions that you want to publish exist in multiple catalogs, you must copy them into a single catalog for publishing. |
See | Netezza Considerations and Limitations When Using the FMTCAT= Options |
Default | If FMTTABLE is not specified, no table is created. You can see only the SAS_PUT( ) function. You cannot see the formats that are published by the macro. |
Interaction | If ACTION=CREATE or ACTION=DROP is specified, messages are written to the SAS log that indicate the success or failure of the table creation or drop. |
Interaction | If FMTTABLE= is specified, both the SAS_PUT( ) function and the format table are dropped. If the table name cannot be found or is incorrect, only the SAS_PUT( ) function is dropped. |
Default | CREATE |
Tip | If the SAS_PUT( ) function was published previously and you specify ACTION=CREATE, you receive warning messages that the function already exists and you are prompted to use REPLACE. If you specify ACTION=DROP and the function does not exist, an error message is issued. |
Default | FENCED |
Restriction | The MODE= argument is supported for Netezza 6.0. The MODE argument is ignored for previous versions of Netezza. |
Tip | There are limited resources available in Netezza when you run in fenced mode. For example, there is a limit to the number of columns available. |
See | Modes of Operation |
See | Special Characters in Directory Names |
%indnzpf; %let indconn = server=netezbase user=user1 password=open1 database=mydb; %indnz_publish_formats(fmtcat= fmtlib.fmtcat);
CREATE FUNCTION sas_put(float , varchar(256)) RETURNS VARCHAR(256) LANGUAGE CPP PARAMETER STYLE npsgeneric CALLED ON NULL INPUT EXTERNAL CLASS NAME 'Csas_putn' EXTERNAL HOST OBJECT '/tmp/tempdir_20090528T135753_616784/formal5.o_x86' EXTERNAL NSPU OBJECT '/tmp/tempdir_20090528T135753_616784/formal5.o_diab_ppc'