PM76193: ERROR IBM7035I IN THE SQL PREPROCESSOR WITH UTF

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Error IBM7035I in the SQL Preprocessor with UTF
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Enterprise PL/I SQL preprocessor users   *
    *                 that use the WIDECHAR data type as SQL host  *
    *                 variables.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: The Enterprise PL/I SQL preprocessor    *
    *                      did not correctly handle a factored     *
    *                      DECLARE statement containing a WIDECHAR *
    *                      variable that is later used in an EXEC  *
    *                      SQL statement as a host variable.       *
    *                                                              *
    *                      For example:                            *
    *                       DCL (W1, W2, W3) WIDECHAR(10)          *
    *                                                              *
    *                      In cases like this the SQL preprocessor *
    *                      would issue the following message:      *
    *                                                              *
    *                      IBM7035I S Host variable W1 does not    *
    *                               have a valid host data type.   *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    The Enterprise PL/I SQL preprocessor mishandled a factored
    DECLARE statement containing a WIDECHAR variable that is later
    used as a host variable.
    

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    PM76193

  • 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-10-30

  • Closed date

    2012-11-29

  • Last modified date

    2012-12-04

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

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

    PM76195 UK83880

Modules/Macros

  • IBMMSQL
    

Fix information

  • Fixed component name

    ENT PL/I FOR Z/

  • Fixed component ID

    5655H3100

Applicable component levels

  • R390 PSY UK83880

       UP12/11/30 P F211

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:

z/OS family

Software version:

3.9

Reference #:

PM76193

Modified date:

2012-12-04

Translate my page

Machine Translation

Content navigation