PM29226: PROVIDE A SAMPLE JOB FOR MIGRATING EXTERNAL SQL PROCEDURES TO NATIVE SQL PL

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR provides sample job DSNTEJ67 which initiates the
  process of converting source for an external SQL procedure into
  source for a native SQL procedure. REXX services, native SQL PL
  and the HOST(SQLPL) checkout precompiler are combined to
  extract, inspect, analyze and convert external SQL procedure
  source code. The appropriate set of native SQL procedure
  options are applied and a listing of the modified SQL procedure
  source code is produced.
  .
  This fix provides a customized DSNTEJ67 in NEW.SDSNSAMP
  that needs to be updated if PH067S03 RC:08 SETUPDB2 occurs.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of SQL procedures with DB2 Version 9.1 *
  *                 for z/OS and DB2 Version 10.1 for z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Provide a sample job to demonstrate     *
  *                      the initial process of migrating the    *
  *                      source for an external SQL procedure    *
  *                      to the source for a native SQL          *
  *                      procedure.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR adds a new sample job DSNTEJ67 which utilizes the
  HOST(SQLPL) precompiler in a process to initiate the conversion
  of external SQL procedure source code to native SQL procedure
  source code. This sample job can be customized to begin the
  migration activity of your own external SQL procedures which
  were produced using the DB2 SQL procedure processor DSNTPSMP.
  
  Additional keywords: SQLPL SQLSTOREDPROC SQLPROC
  

Problem conclusion

Temporary fix

Comments

• This APAR requires APAR PM40502.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK71501 UK71502

Modules/Macros

• DSNHPUT2 DSNHREAD DSNTEJ67 DSN8EF1  DSN8EN1
  DSN8ERL1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK71501

     UP11/09/16 P F109

• R910 PSY UK71502

     UP11/09/16 P F109

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.