IBM Support

PM76195: 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

    PM76195

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

  • Closed date

    2012-11-29

  • Last modified date

    2012-12-04

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

    PM76193

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

    UK83881

Modules/Macros

  • IBMMSQL
    

Fix information

  • Fixed component name

    ENT PL/I FOR ZO

  • Fixed component ID

    5655W6700

Applicable component levels

  • R410 PSY UK83881

       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.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSY2V3","label":"IBM Enterprise PL\/I for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
04 December 2012