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: