PM64961: THE ENTERPRISE PL/I SQL PREPROCESSOR DOES NOT HANDLE 'SQL TYPE IS' DECLARES CORRECTLY

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The Enterprise PL/I SQL preprocessor does not handle 'SQL TYPE
    IS' declares correctly when they are in a group of variables
    in a single DECLARE statement.  Messages IBM1352I E,
    IBM1306I E and IBM1122I W are received.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Enterprise PL/I SQL preprocessor users.  *
    ****************************************************************
    * PROBLEM DESCRIPTION: The Enterprise PL/I SQL preprocessor    *
    *                      did not correctly handle a DECLARE      *
    *                      statement containing more than one      *
    *                      variable name where one of the          *
    *                      variables being declared is a large     *
    *                      object (BLOB, CLOB, DBCLOB) and where   *
    *                      the delimiter of the previous variable  *
    *                      would begin the following line.         *
    *                                                              *
    *                      For example:                            *
    *                       dcl rcParm char(286) var               *
    *                         , pm_object  sql type is blob (15m)  *
    *                         , j fixed bin (31)                   *
    *                         ...                                  *
    *                                                              *
    *                      In cases like this the SQL preprocessor *
    *                      would produce unpredictable results.    *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    The Enterprise PL/I SQL preprocessor mishandled a DECLARE
    statement containing more than one variable with at least one
    being a large object variable and where each line begins with
    the delimiter of the previous variable declare.
    

Problem conclusion

  • The Enterprise PL/I SQL preprocessor now correctly handles these
    cases and completes normally.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM64961

  • Reported component name

    ENT PL/I FOR ZO

  • Reported component ID

    5655W6700

  • Reported release

    410

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-05-18

  • Closed date

    2012-09-28

  • Last modified date

    2012-11-02

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

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

    UK82217

Modules/Macros

  • IBMMSQL
    

Fix information

  • Fixed component name

    ENT PL/I FOR ZO

  • Fixed component ID

    5655W6700

Applicable component levels

  • R410 PSY UK82217

       UP12/10/04 P F210

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:

Enterprise PL/I for z/OS

Software version:

4.1

Reference #:

PM64961

Modified date:

2012-11-02

Translate my page

Machine Translation

Content navigation