Activating SOURCE EXPLAIN

You can use SOURCE EXPLAIN to explain SQL statements that are embedded in a source program or SPUFI input. SOURCE EXPLAIN is performed from within an ISPF/PDF editor, so you can have an SQL statement explained while editing a source program or SPUFI input. Install and customize the REXX EXEC FPEJXPLS in rHilev.rte_name.RKO2SAMP.

Before you begin

Ensure the following requirements are met before completing this step.

Required authorizations
  • ALTER privilege on your EXEC library
Other requirements
  • Db2 EXPLAIN is activated
  • You want to use EXPLAIN on an SQL statement from within an ISPF edit session

Procedure

  1. Copy FPEJXPLS to your EXEC library.
  2. Rename the copy of FPEJXPLS to EXPLAIN.
  3. Open the renamed REXX EXEC.
  4. Find the section "ICAT / User" in the file and set the variable hlq3.1 to rHilev.
  5. Customize the REXX EXEC according to your needs. See the customization options in the header of the REXX EXEC.