PM64961: THE ENTERPRISE PL/I SQL PREPROCESSOR DOES NOT HANDLE 'SQL TYPE IS' DECLARES CORRECTLY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The Enterprise PL/I SQL preprocessor does not handle 'SQL TYPE
  IS' declares correctly when they are in a group of variables
  in a single DECLARE statement.  Messages IBM1352I E,
  IBM1306I E and IBM1122I W are received.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Enterprise PL/I SQL preprocessor users.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Enterprise PL/I SQL preprocessor    *
  *                      did not correctly handle a DECLARE      *
  *                      statement containing more than one      *
  *                      variable name where one of the          *
  *                      variables being declared is a large     *
  *                      object (BLOB, CLOB, DBCLOB) and where   *
  *                      the delimiter of the previous variable  *
  *                      would begin the following line.         *
  *                                                              *
  *                      For example:                            *
  *                       dcl rcParm char(286) var               *
  *                         , pm_object  sql type is blob (15m)  *
  *                         , j fixed bin (31)                   *
  *                         ...                                  *
  *                                                              *
  *                      In cases like this the SQL preprocessor *
  *                      would produce unpredictable results.    *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  The Enterprise PL/I SQL preprocessor mishandled a DECLARE
  statement containing more than one variable with at least one
  being a large object variable and where each line begins with
  the delimiter of the previous variable declare.
  

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:

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

  UK82217

Modules/Macros

•    IBMMSQL
  

Fix information

• Fixed component name

  ENT PL/I FOR ZO

• Fixed component ID

  5655W6700

Applicable component levels

• R410 PSY UK82217

     UP12/10/04 P F210

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.