PK14153: SQLCODE206 ON GEN OF VIEW WITH QUOTED COLUMN NAME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool an sqlcode206 can result from a GEN
  of a VIEW that contains a column with a quoted name. Problem
  only occurs when RUNSQLID is specified.
  For example:
    "NAME" becomes """NAME""" in CREATE VIEW statement
  .
  Additional symptoms: reserved restricted quote quotes
  sqlcoden206 sqlcode104 sqlcoden104 206 104 SEL
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who use    *
  *                 GEN where view objects have quoted column    *
  *                 names, are affected.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: GEN incorrectly  creates  triple quotes *
  *                      for  view  objects  that  have   quoted *
  *                      column names, when masking or SQLID  is *
  *                      specified.                              *
  *                      .*                                      *
  *                      An SQL CODE -206 can result from a GEN  *
  *                      of a VIEW that contains a column with   *
  *                      a quoted name. Problem only occurs when *
  *                      RUNSQLID is specified.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SQLCODE -206 occurred on GEN of VIEW with quoted column name.
  

Problem conclusion

• ADB2REG module has been changed to correct the problem.
  

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:

  UK09423

Modules/Macros

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK09423

     UP05/12/06 P F512

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.