PK30729: PROBLEM WHEN USING AS IN THE SQL E.G. SELECT COL1 AS BALANCE IN SOURCEOF CONTROL

APAR status

• Closed as unreproducible in next release.

Error description

• Problem when using AS in the SQL e.g. SELECT COL1 As BALANCE in
  Source of control. Column will display correctly but will not
  work when you perform an update.  This fix will allow the user
  with in the format of a control to name the column.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Table Editor.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Problem when using AS in the SQL e.g.   *
  *                      SELECT COL1 As BALANCE in Source of     *
  *                      control. Column will display correctly  *
  *                      but will not work when you perform an   *
  *                      update.  This fix will allow the user   *
  *                      with in the format of a control to      *
  *                      name the column.                        *
  ****************************************************************
  * RECOMMENDATION: PK30729 was included in FP8 of ETIMP.        *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• PK30729 was included in FP8 of ETIMP.
  

APAR Information

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

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

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R130 PSN

     UP