PK66568: WSL CLONE APPENDS QUOTATION MARKS TO LOWERCASE COLUMNS RESULTING IN SQLCODEN206 IS NOT A COLUMN OF AN INSERTED TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool WSL CLONE function appended
  quotation marks to unquoted lowercase column names resulting
  in a SQLCODE -206 error:
  DSNT408I SQLCODE = -206, ERROR:  aaa_aaaaaaaa_aaaa_aa IS NOT A
  COLUMN OF AN INSERTED TABLE, UPDATED TABLE, OR ANY TABLE
  IDENTIFIED IN A FROMCLAUSE, OR IS NOT A COLUMN OF THE
  TRIGGERING TABLE OF A TRIGGER
  Additional search args: double quotes 42703 SQLSTATE
  

Local fix

• EDIT WSL to remove quotation marks after clone process
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2  Admin & Object Comparison Tool *
  *                 who  uses WSL cloning  function having lower *
  *                 case characters.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: When WSL has lower case (example an SQL *
  *                      INSERT),cloning it  results to a column *
  *                      names  wrapped in quotes.   Running the *
  *                      cloned WSL with the quoted column names *
  *                      results in SQLCODE -206.                *
  *                                                              *
  *                      This is due to the given  workname      *
  *                      (to be quoted) is not verified for      *
  *                      lower case characters.                  *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Changes are done to verify the given workname to be quoted is in
  lower case characters along with verifying upper case characters
  along with other symbols and new line extenders.
  

Problem conclusion

• The problem has been fixed.
  

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

•    ADB2FMT  ADB2WCL  ADB28MC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK41563

     UP08/11/21 P F811

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.