PI16570: SQL UPDATE LABEL SUPPORT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• PMR 67850,999,000 - SQL UPDATE label support
  
  Prerequisites:  All PTFs to date.
  
  Date reported: 04/10/2014
  
  Severity: Medium
  
  Users Affected:
   All IMU users of MU V4.1
  
  Problem Description:
   SQL Dynamic translator macro is flagging 'SQL UPDATE &label'
   syntax.
  
  Problem Summation
   Usage of label on SQL UPDATE is not supported by DB2 but EZT
   Plus allows it.
  
   IMU Dynamic SQL translator disallows label because DB2 does not
   support it.
  
  Problem Conclusion:
   The EASYT007 macro was changed to remove label and label
   references in SQL UPDATE.
  
   Example:   SQL UPDATE &table A SET A.COMPANY = '001'
  
                is translated to
  
              SQL UPDATE &TABLE SET COMPANY = '001'
  
  Impact on converted programs
   There  is no impact on any previously converted programs.
  
  Changed Modules in FSOFT01.V4R1M0.SFSYFJCC
   EASYT007 - existing macro
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All UMU V4.1 users.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQL Dynamic translator macro is         *
  *                      flagging 'SQL UPDATE &label' syntax.    *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  Usage of label on SQL UPDATE is not supported by DB2 but EZT
  Plus allows it.
  
  IMU Dynamic SQL translator disallows label because DB2 does not
  support it.
  

Problem conclusion

• The EASYT007 macro was changed to remove label and label
  references in SQL UPDATE.
  
  Example:   SQL UPDATE &table A SET A.COMPANY = '001'
  
               is translated to
  
             SQL UPDATE &TABLE SET COMPANY = '001'
  
  Impact on converted programs
   There  is no impact on any previously converted programs.
  

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:

Modules/Macros

•    FSYET007
  

Fix information

• Fixed component name

  MIGRATION UTILI

• Fixed component ID

  5697N4400

Applicable component levels

• R410 PSY UI19652

     UP14/07/22 P F407

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.