PM76195: ERROR IBM7035I IN THE SQL PREPROCESSOR WITH UTF

Obtain the fix for this APAR.

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