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

Obtain the fix for this APAR.

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