PM00767: SAVING TDS/Z USER TABLE UPDATE PLACES LET STATEMENTS IN REVERSE ORDER.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SAVING TDS/Z USER TABLE UPDATE PLACES LET STATEMENTS IN REVERSE
  ORDER.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Decision Support for z/OS users.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: When saving an update definition to a   *
  *                      dataset, any LET statements are         *
  *                      saved in reverse order. If a LET        *
  *                      statement uses a field defined          *
  *                      in the previous LET statement then an   *
  *                      error will occur when the update        *
  *                      definition is then processed by TDS.    *
  ****************************************************************
  * RECOMMENDATION: APPLY THE PTF FIXING THIS APAR               *
  ****************************************************************
  When saving an update definition TDS retrieves all the LET
  statements from the TDS system table DRLUPDATELETS. The SQL
  statement does not have an ORDER BY statement on it, so the
  LET statements are not being fetched in the order that they
  need to be in for execution (based on the LET_NO column).
  

Problem conclusion

• Saving an update definition to a dataset will now save the
  LET statements in the correct order.
  701Y
  710Y
  801Y
  DRLEATUP
  

Temporary fix

• n/a
  

Comments

APAR Information

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

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

  UK52045 UK52046 UK52047

Modules/Macros

• DRLEATUP
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R701 PSY UK52045

     UP09/11/19 P F911

• R710 PSY UK52046

     UP09/11/19 P F911

• R801 PSY UK52047

     UP09/11/19 P F911

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.