PM79229: SQL REJECTS WIDECHAR(N) VARYING WHEN N > 2000

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • SQL rejects WIDECHAR(n) VARYING when n > 2000
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: SQL users with host variables declared as    *
    *                 WCHAR(N) VARYING where n > 2000              *
    ****************************************************************
    * PROBLEM DESCRIPTION: the use of such variables in SQL        *
    *                      statements would cause the SQL          *
    *                      preprocessor tp reject them as illegal  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • The SQL preprocessor had been defining these to the SQL backend
    as LONGVAR, but SQL has dropped support for that type and they
    should be defined simply as VARYING. The SQL preprocessor has
    been changed to do this.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM79229

  • Reported component name

    ENT PL/I FOR ZO

  • Reported component ID

    5655W6700

  • Reported release

    420

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-14

  • Closed date

    2012-12-14

  • Last modified date

    2013-01-02

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

    PM79228

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

    UK90365 UK90364

Modules/Macros

  • IBMMSQL
    

Fix information

  • Fixed component name

    ENT PL/I FOR ZO

  • Fixed component ID

    5655W6700

Applicable component levels

  • R420 PSY UK90364

       UP12/12/18 P F212

  • R430 PSY UK90365

       UP12/12/18 P F212

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

Reference #:

PM79229

Modified date:

2013-01-02

Translate my page

Machine Translation

Content navigation