full-path-to-pkglibdir/SAS
on
the whole database array (master and all segments) , where full-path-to-pkglibdir
is
the path that was defined during installation.
full-path-to-pkglibdir/SAS
directory
on all nodes, where full-path-to-pkglibdir
is the path that
was defined during installation.
full-path-to-pkglibdir/SAS
directory,
the publishing macro uses the database, schema, and model name as
the object filename to avoid potential naming conflicts.
%let indconn = user=youruserid password=yourpwd dsn=yourdsn schema=yourschema;
%let indconn = user=youruserid password=yourpwd database=yourdb server=yourserver schema=yourschema;
specifies the Greenplum user name (also called the user ID) that is used to connect to the database.
specifies the password that is associated with your Greenplum user ID.
Tip | Use only PASSWORD=, PASS=, or PW= for the password argument. PWD= is not supported and causes an error. |
specifies the configured Greenplum ODBC data source to which you want to connect.
Requirement | You must specify either the DSN= argument or the SERVER= and DATABASE= arguments in the INDCONN macro variable. |
specifies the Greenplum server name or the IP address of the server host.
Requirement | You must specify either the DSN= argument or the SERVER= and DATABASE= arguments in the INDCONN macro variable. |
specifies the Greenplum database that contains the tables and views that you want to access.
Requirement | You must specify either the DSN= argument or the SERVER= and DATABASE= arguments in the INDCONN macro variable. |
specifies the schema name for the database.
Tip | If you do not specify a value for the SCHEMA argument, the value of the USER argument is used as the schema name. The schema must be created by your database administrator. |
specifies the psql port number.
Default | 5432 |
Requirement | The server-side installer uses psql, and psql default port is 5432. If you want to use another port, you must have the UNIX or database administrator change the psql port. |
specifies the name of a Greenplum database to which the SAS_PUT( ) function and the format functions are published.
Restriction | If you specify DSN= in the INDCONN macro variable, do not use the DATABASE argument. |
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 %INDGP_PUBLISH_FORMATS Macro. |
specifies the name of the format catalog file that contains all user-defined formats that were created by the FORMAT procedure and are made available in Greenplum.
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 Greenplum. | |
Interactions | If the format definitions that you want to publish exist in multiple catalogs, you must copy them into a single catalog for publishing. |
If you do not use the default catalog name (FORMATS) or the default library (WORK or LIBRARY) when you create user-defined formats, you must use the FMTSEARCH system option to specify the location of the format catalog. For more information, see PROC FORMAT in the Base SAS Procedures Guide. |
specifies the name of the Greenplum table that contains all formats that the %INDGP_PUBLISH_FORMATS macro creates and that the SAS_PUT( ) function supports. The format table contains the columns shown in following table.
Column Name
|
Description
|
---|---|
FMTNAME
|
specifies the name of
the format.
|
SOURCE
|
specifies the origin
of the format. SOURCE can contain one of these values:
SAS
supplied by SAS
PROCFMT
User-defined with PROC
FORMAT
|
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. |
specifies that the macro performs one of these actions:
creates the SAS_PUT( ) function.
overwrites the current SAS_PUT( ) function, if a SAS_PUT( ) function is already registered.
causes the SAS_PUT( ) function to be dropped from the Greenplum database.
Default | CREATE |
Tip | If the SAS_PUT( ) function has been previously defined and you specify ACTION=CREATE, you receive warning messages from Greenplum. If the function has been previously defined and you specify ACTION=REPLACE, no warnings are issued. |
specifies a directory that contains diagnostic files.
See | Special Characters in Directory Names |
%let indconn = user=user1 password=xxxx dsn=dsnx34 schema=block; %indgp_publish_formats(fmtcat=work.formats);
CREATE OR REPLACE FUNCTION dbitest.homeeq_5_em_classification ( float8, float8, float8, float8, float8, varchar(32), float8, float8, varchar(32), float8, float8 ) RETURNS varchar(33) AS '/usr/local/greenplum-db-3.3.4.0/lib/postgresql/SAS/sample_dbitest_homeeq_5.so', 'homeeq_5_em_classification'