PM87753: BETTER SUPPORT FOR PP(SQL) USED ON PROGRAMS WITH NO SQL

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Better support for PP(SQL) used on programs with no SQL
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Enterprise 4.3 users of the integrated SQL   *
    *                 preprocessor                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: If the PP(SQL) is specified against a   *
    *                      source program that contains no EXEC    *
    *                      SQL statements, then the DB2 backend of *
    *                      the SQL preprocessor will not be run.   *
    *                      This means that no DBRM will be         *
    *                      created. However, some users want a     *
    *                      DBRM created even in this case.         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • A new SQL preprocessor option called EMPTYDBRM has been added to
    the SQL preprocessor. Under this option, an empty DBMR will be
    created for programs containing no EXEC SQL statements. The
    default is NOEMPTYDBRM, and this default preserves the behavior
    before this APAR. The option will be documented in the next
    release.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM87753

  • Reported component name

    ENT PL/I FOR ZO

  • Reported component ID

    5655W6700

  • Reported release

    430

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-24

  • Closed date

    2013-04-25

  • Last modified date

    2013-05-06

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

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

    UK93797

Modules/Macros

  • IBMMSQL
    

Fix information

  • Fixed component name

    ENT PL/I FOR ZO

  • Fixed component ID

    5655W6700

Applicable component levels

  • R430 PSY UK93797

       UP13/04/30 P F304

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

Document information


More support for:

Enterprise PL/I for z/OS

Software version:

4.3

Reference #:

PM87753

Modified date:

2013-05-06

Translate my page

Machine Translation

Content navigation