Validation of Publishing Functions

Validating the Publishing of the SAS_COMPILEUDF, SAS_COPYUDF, SAS_DIRECTORYUDF, and SAS_DEHEXUDF Functions

Validating the Publishing of the SAS_EP Function

Validating the Publishing of the SAS_COMPILEUDF, SAS_COPYUDF, SAS_DIRECTORYUDF, and SAS_DEHEXUDF Functions

To validate that the SAS_COMPILEUDF, SAS_COPYUDF, SAS_DIRECTORYUDF, and SAS_DEHEXUDF functions are registered properly under the SASLIB schema in the specified database, follow these steps.

Use psql to connect to the database.
```
psql -d databasename
```
You should receive the following prompt.
```
databasename=#
```

At the prompt, enter the following command.

select prosrc from pg_proc f, pg_namespace s where f.pronamespace=s.oid 
    and upper(s.nspname)='SASLIB';

You should receive a result similar to the following:

SAS_CompileUDF
SAS_CopyUDF
SAS_DirectoryUDF
SAS_DehexUDF

Validating the Publishing of the SAS_EP Function

To validate that the SAS_EP function is registered properly under the specified schema in the specified database, follow these steps.

Use psql to connect to the database.
```
psql -d databasename
```
You should receive the following prompt.
```
databasename=#
```

At the prompt, enter the following command.

select proname, prosrc, probin, nspname FROM pg_catalog.pg_namespace n
  JOIN pg_catalog.pg_proc p ON pronamespace = n.oid WHERE proname = 'sas_ep'
  or proname = 'sas_ep_describe';

You should receive a result similar to the following:

    proname      |     prosrc      |                   probin                    | nspname
-----------------+-----------------+---------------------------------------------+---------
 sas_ep_describe | SAS_EP_Describe | $libdir/SASEPHome/sasexe/sasep_tablefunc.so | <schema>
 sas_ep          | SAS_EP          | $libdir/SASEPHome/sasexe/sasep_tablefunc.so | <schema>

Exit psql.
```
\q
```

Last updated: February 9, 2017