PI88314: EXECUTING GEN ON A VIEW, WITH 'RUN SQLID' NOT BLANK, MAY GENERATE INVALID DDL, RESULTING IN SQLCODE -206 WHEN EXECU

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Executing GEN on a view, with option 'Run SQLID' not blank,
  may generate DDL containing an extraneous owner.tablename on a
  column name.  An attempt to execute that DDL would lead to the
  following error:
  
  SQLCODE = -206, ERROR: owner.tablename.columname IS NOT VALID
  IN THE CONTEXT WHERE IT IS USED
  

Local fix

• If possible, set 'RUN SQLID' to blank.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 and DB2 Object Comparison Tool for           *
  *                 z/OS who use the command GEN or              *
  *                 DDL to generate VIEW DDL.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When GEN option 'RUN SQLID' is          *
  *                      specified, a DDL or GEN line            *
  *                      command against a VIEW may              *
  *                      result in error SQLCODE=-206/           *
  *                      SQLCODEN206.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When executing the DDL or GEN command against a view,
  with GEN option 'RUN SQLID' specified, a fully qualified
  column name was generated. If the column's table was not
  referenced in the FROM clause, then DB2 issued the following
  error message:
  
  SQLCODE = -206, ERROR: owner.table.column IS NOT VALID
  IN THE CONTEXT WHERE IT IS USED
  
  With this APAR applied, only the column name is generated.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI52910 UI52911

Modules/Macros

•    ADB2PA   ADB2REG  ADB2REH
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI52910

     UP17/12/27 P F712

• RC10 PSY UI52911

     UP17/12/27 P F712

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.