PQ74192: GEN AND DDL COMMAND GET SYNTAX ERRORS ON VIEW WHEN IT CONTAINS AWHERE CLAUSE ARITHMETIC EXPRESSION GROUPED WITH PARENTHESIS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When an arithmetic expression in a where clause is grouped
  together with parenthesis it results in an error for the GEN
  and DDL line commands in Admin Tool:
  EXAMPLE:
  WHERE  (A.QTY - A.QTY_RESERVED)  > 0 AND...
  ERROR:
  ADB2GEN - Ended normally
  Token number = 0051, Token =A
  

Local fix

• If possible, remove the parenthesis.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 ADMIN TOOL who use GEN and      *
  *                 DDL line commands are affected. See          *
  *                 Problem Description for other Aparfixes      *
  *                 that are included.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The fixes for problems reported in the  *
  *                      following APARs are included:           *
  *                      *                                       *
  *                      PQ74192 : When an arithmetic expression *
  *                      in a WHERE clause is grouped together   *
  *                      with parenthesis it results in an error *
  *                      for the GEN and DDL line commands.      *
  *                      *                                       *
  *                      PQ59167 : Panel ADB2GEN does not GEN a  *
  *                      GRANT ACCESS ON VIEW unless the CREATE  *
  *                      VIEW option is specified as Yes.        *
  *                      *                                       *
  *                      PQ60024 : Using GEN to CREATE a TRIGGER *
  *                      object with NEW OWNER specified, does   *
  *                      GEN the CREATE DDL for the TRIGGER, but *
  *                      fails to apply NEW OWNER to objects     *
  *                      within the TRIGGER action text, between *
  *                      the BEGIN ATOMIC and END statements.    *
  *                      *                                       *
  *                      PQ65927 : DB2 Admin Tool GEN MIG and    *
  *                      DDL commands are affected. NEWOWNER is  *
  *                      not applied to all objects during GEN   *
  *                      processing. For example: VIEW owner is  *
  *                      not changed. Tables and Indexes are     *
  *                      assigned a new owner, but other         *
  *                      dependent objects such as VIEWs are not *
  *                      *                                       *
  *                      PQ71228 : SQLCODE20100 was received     *
  *                      from GEN of a table that contains a     *
  *                      TRIGGER that was defined by a different *
  *                      owner than the owner of the TABLESPACE. *
  *                      TRIGGER contains invalid 3-part names,  *
  *                      where the first qualifier is the        *
  *                      TRIGGER owner, which should not be part *
  *                      of the name.                            *
  *                      *                                       *
  *                      PQ71340 : DB2 Admin Tool panel          *
  *                      ADB21TSE receives ONCODE9050 when       *
  *                      processing a SELECT prototype and if    *
  *                      a WHERE clause is included in the       *
  *                      SELECT.                                 *
  *                      *                                       *
  *                      PQ72005 : DB2 Administration Tool is    *
  *                      not generating REBIND DDL during        *
  *                      execution of GEN command. Job output    *
  *                      shows that rebind was found and         *
  *                      reported; but, when inspecting dataset  *
  *                      containing DDL, the REBIND DDL is       *
  *                      missing.                                *
  *                      *                                       *
  *                      PQ72009 : DB2 Administration Tool       *
  *                      generates invalid view SQL when using   *
  *                      either the DDL or GEN line commands,    *
  *                      if the view contains an internal        *
  *                      function like YEAR, MONTH, DAY, etc.    *
  *                      *                                       *
  *                      PQ73409 : In DB2 Automation Tool panel  *
  *                      ADB21T the DDL command is used on a     *
  *                      single VIEW name. If other dependent    *
  *                      VIEW(s) exist, they are included in     *
  *                      the DDL output.                         *
  *                      *                                       *
  *                      PQ74300 : In DB2 Automation Tool panel  *
  *                      ADB21T the DDL command is used on a     *
  *                      single VIEW name. If other dependent    *
  *                      VIEW(s) exist, they are included in     *
  *                      the DDL output.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Problems reported in the following APARs are fixed:
  PQ59167
  PQ60024
  PQ65927
  PQ71228
  PQ71340
  PQ72005
  PQ72009
  PQ73409
  PQ74192
  PQ74300
  

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:

  UQ77768

Modules/Macros

•    ADB2CMM  ADB2FMT  ADB2GEN  ADB2GENS ADB2GEN6
  ADB2MSK  ADB2PA   ADB2REE  ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R410 PSY UQ77768

     UP03/06/19 P F306

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.