Setting up support for external SQL procedures

If you plan to create external SQL procedures by using DSNTPSMP or IBM® Data Studio, you need to complete some additional setup. Alternatively, you can write your own JCL to create external SQL procedures, in which case you do not need to perform this setup.

About this task

DSNTPSMP is a REXX stored procedure that you can use to create and prepare external SQL procedures. DSNTPSMP is also used by IBM Data Studio to create external SQL procedures. When DSNTPSMP is invoked, DB2® uses the DSNTPSMP REXX EXEC, which is in the prefix.SDSNCLST data set.

Procedure

To set up support for external SQL procedures:

  1. If DSNTPSMP does not already exist, run job Start of changeDSNTIJRTEnd of change to create this stored procedure.
  2. Install DB2 REXX Language Support.
  3. Set up a WLM environment in which to run DSNTPSMP and create a WLM startup procedure.
    Recommendation: Start of changeIf you do not have a WLM environment defined to run DSNTPSMP, use the core WLM environment DSNWLM_REXX.End of change