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

A fix is available

Subscribe

You can track all active APARs for this component.

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

APAR Information

  • APAR number

    PM29226

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-12-17

  • Closed date

    2011-08-31

  • Last modified date

    2012-04-04

  • 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM29226

Modified date:

2012-04-04

Translate my page

Machine Translation

Content navigation