Validating the Publishing of SAS_COMPILEUDF and SAS_DELETEUDF Functions and Global Variables

To validate that the SAS_COMPILEUDF and SAS_DELETEUDF functions and global variables are created properly, follow these steps.
  1. Connect to your DB2 database using Command Line Processor (CLP).
  2. Enter the following command to verify that the SASUDF_COMPILER_PATH global variable was published.
    values(saslib.sasudf_compiler_path)
    You should receive a result similar to one of the following.
    /usr/vac/bin      /* on AIX */
    /usr/bin        /* on Linux */
    
  3. Enter the following command to verify that the SASUDF_DB2PATH global variable was published.
    values(saslib.sasudf_db2path)
    You should receive a result similar to the following.
    /users/db2v10/sqllib
    In this example, /users/db2v10 is the value of db2instancepath that was specified during installation and /users/db2v10/sqllib is also where the SAS_COMPILEUDF function was published.
  4. Enter the following command to verify that theSAS_COMPILEUDF and SAS_DELETEUDF functions were published.
    select funcname, implementation from syscat.functions where
       funcschema='SASLIB'
    
    You should receive a result similar to the following.
    FUNCNAME                         IMPLEMENTATION
    -------------------------------------------------------------
    SAS_DELETEUDF
    /users/db2v10/sqllib/function/SAS/SAS_DeleteUDF!SAS_DeleteUDF
    SAS_COMPILEUDF
    /users/db2v10/sqllib/function/SAS/SAS_CompileUDF!SAS_CompileUDF
    
Last updated: February 9, 2017