PM79228: 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: All Enterprise PL/I SQL preprocessor users   *
    *                 with programs having VARYING GRAPHIC or      *
    *                 VARYING WIDECHAR variables greater than 2000 *
    *                 characters in length that are used as host   *
    *                 variables.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: The Enterprise PL/I SQL preprocessor    *
    *                      would assign the DB2 datatype LONG      *
    *                      VARGRAPHIC in its interaction with the  *
    *                      DB2 Coprocessor for these types of host *
    *                      variables.  DB2 has recently deprecated *
    *                      the LONG VARGRAPHIC datatype causing    *
    *                      the following error to be issued in     *
    *                      certain situations:                     *
    *                      IBM7042I E DSNH080I DSNHSM3D STRING     *
    *                                 VARIABLE "H" IS NOT          *
    *                                 "VARCHAR" TYPE               *
    *                      The compile would fail with an RC=4 on  *
    *                      the SQL preprocessor step.              *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    The Enterprise PL/I SQL preprocessor assigned a deprecated DB2
    datatype value to VARYING GRAPHIC and VARYING WIDECHAR host
    variables that were greater than 2000 characters in length.
    

Problem conclusion

  • The Enterprise PL/I SQL preprocessor now assigns a supported DB2
    datatype value to host variables that are either VARYING GRAPHIC
    or VARYING WIDECHAR and are greater than 2000 characters in
    length.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM79228

  • Reported component name

    ENT PL/I FOR Z/

  • Reported component ID

    5655H3100

  • Reported release

    390

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-14

  • Closed date

    2013-01-10

  • Last modified date

    2013-02-04

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

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

    PM79229 UK90880

Modules/Macros

  • IBMMSQL
    

Fix information

  • Fixed component name

    ENT PL/I FOR Z/

  • Fixed component ID

    5655H3100

Applicable component levels

  • R390 PSY UK90880

       UP13/01/15 P F301

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:

z/OS family

Software version:

3.9

Reference #:

PM79228

Modified date:

2013-02-04

Translate my page

Machine Translation

Content navigation