PK62741: PANEL ADB21TUP "BUILD SQL UPDATE PROTOTYPE" FOLDS INPUT TO UPPERCASE. PANELS ADB21TDE AND ADB21TIN INCLUDED IN APAR.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool panel ADB21TUP  "Build SQL UPDATE
  Prototype" folds input to uppercase.
  

Local fix

• Use PROMPT option to edit SQL syntax to correct the issue.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Admin Tool V7.2  who use        *
  *                 mixed case data for UPDATE and DELETE        *
  *                 prototyping, and for the EDIT command        *
  *                 from those as well as the SELECT and         *
  *                 INSERT prototyping panels.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Mixed case is not supported on panels   *
  *                      ADB21TDE, ADB21TUP,  and for the EDIT   *
  *                      command issued from those panels as     *
  *                      well as ADB21TIN and ADB21TSE.          *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Mixed case support was not yet added for UPDATE and DELETE
  prototyping, and for the EDIT primary command issued from any of
  the prototyping panels. With the Capitalize Data parameter set
  to NO, the data was still folded to uppercase.
  

Problem conclusion

• This fix is for DB2 Admin Tool Version 720 and higher only.
  The above-mentioned panels or fields now support mixed data, as
  well as the EDIT command issued from those panels, In addition,
  several problems related to entering multiple blanks, as well
  as quoting around tokens entered on the prototype panels are
  now fixed.
  

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

•    ADB21TDE ADB21TIN ADB21TSE ADB21TUP ADB221
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK36478

     UP08/05/28 P F805

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.