PK04175: GEN LINE COMMAND GENERATES INVALID TRIGGER SYNTAX.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool is generating invalid trigger syntax
  when the trigger contains a "referencing" clause.  Error
  manifests by creating three part names in the where clause.
  In addition, the "referencing" correlation-name is seen within
  a column definition prefix.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool,  who run   *
  *                 GEN to produce DDL for CREATE TRIGGER, may   *
  *                 be affected.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool was generating  *
  *                      invalid trigger syntax when the trigger *
  *                      contained a "referencing" clause. Error *
  *                      manifested by creating three part names *
  *                      in the where clause. In addition, the   *
  *                      "referencing" correlation-name was seen *
  *                      within a column definition prefix.      *
  *                      .*                                      *
  *                      In some circumstances, the created DDL  *
  *                      was in error because columns listed in  *
  *                      the UPDATE OF clause were qualified.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• The required support was missing and it now has been added.
  Apply the fix.
  

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:

  UK02646

Modules/Macros

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK02646

     UP05/04/27 P F504

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.