PK05294: INVALID VIEW SYNTAX FROM GEN AND MIG ON JOINED VIEWS WHEN RUNSQLID VALUE IS SPECIFIED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool a GEN or MIG line command on a VIEW
  that is a VIEW of a join of two tables can produce invalid
  syntax when RUNSQLID is specified. Using RUNSQLID <NONE> will
  produce correct VIEW syntax.
  .
  Invalid syntax appears as 3-part qualified names with the first
  qualifier as double quotes  "" as seen in the following example:
  .
  CREATE VIEW CORPQXPS.PS_AR_POST_ACT_LVW(POST_ACTION,
  LANGUAGE_CD,
       DESCR, DESCRSHORT) AS
     SELECT SUBSTR("".XLATTABLE.FIELDVALUE, 1, 1),
            "".XLATTABLE.LANGUAGE_CD, "".XLATTABLE.XLATLONGNAME,
            "".XLATTABLE.XLATSHORTNAME
       FROM XLATTABLE
       WHERE "".XLATTABLE.FIELDNAME = 'POST_ACTION'
         AND "".XLATTABLE.LANGUAGE_CD <>(
         SELECT CORPQXPS.PSOPTIONS.LANGUAGE_CD
           FROM CORPQXPS.PSOPTIONS) ;
  

Local fix

• Use RUNSQLID <NONE> and modify SQLIDs as needed.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool who         *
  *                 run GEN to produce DDL for Views and         *
  *                 Triggers with unqualified columns names,     *
  *                 and with SQLID set to anything other than    *
  *                 blanks or <NONE>, are affected.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: GEN or MIG line command on a VIEW that  *
  *                      is a VIEW of a join of two tables can   *
  *                      produce invalid syntax when RUNSQLID    *
  *                      is specified. Using RUNSQLID <NONE>     *
  *                      will produce correct VIEW syntax.       *
  *                      .*                                      *
  *                      Invalid syntax appears as 3-part names  *
  *                      with the first qualifier as "" double   *
  *                      quotes.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Invalid VIEW syntax from GEN AND MIG on joined VIEWS was given
  when RUNSQLID value was specified.
  

Problem conclusion

• The unqualified columns are qualified as "".tablename.columnname
  in error. The ADB2REG module has been changed so that this
  behavior doesn't occur.
  

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

•    ADB2PA   ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK04850

     UP05/06/30 P F506

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.