PI92995: CM BATCH OR OBJECT COMPARE GENERATES INCORRECT VIEW DDL WORKLIST EXECUTION ENDS SQLCODE -204 (SQLCODEN204)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CM Batch or Object Compare generates an incorrect column
  qualification when generating view DDL in worklist, resulting
  in following error when worklist is run
  
  sqlerror on CREATE command, PREPARE
  function
  DSNT408I SQLCODE = -204, ERROR: >schemaname<.>columname< IS AN
  UNDEFINED NAME
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Object Comparison           *
  *                 Tool for z/OS who use Object Compare         *
  *                 to compare a view DDL with catalog           *
  *                 objects.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When Object Compare option 'RUN         *
  *                      SQLID' is specified when comparing      *
  *                      a view, the SQLID is appended as        *
  *                      the schema of a table name in a         *
  *                      FROM clause. When the DDL is            *
  *                      executed, the result may be error       *
  *                      SQLCODE=-204 / SQLCODEN204.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When comparing a simplified view such as the following,
  with option 'RUN SQLID' specified:
  
  (
   CREATE VIEW viewname AS
   WITH MOVEMENT AS(SELECT ..
                      FROM ..
                      WHERE..)
    ), "RESULT" AS(SELECT ..
                 FROM ..
                   WHERE..
                   ..)
    SELECT ..
    FROM "RESULT";
  
  The generated DDL shows the specified sqlid appended as
  the schema of the table RESULT in the FROM clause, yielding
  "sqlid"."RESULT", instead of just "RESULT". As no such
  table exists, executing the generated DDL may result in:
  
  DSNT408I SQLCODE = -204, ERROR: sqlid.RESULT IS AN
  UNDEFINED NAME
  DSNT418I SQLSTATE = 42704 SQLSTATE RETURN CODE
  

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:

  UI55049 UI55050

Modules/Macros

•    ADB2PA7
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI55049

     UP18/04/10 P F804

• RC10 PSY UI55050

     UP18/04/10 P F804

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.