PI07144: ERROR RUNNING ADB2GEN WITH A VIEW.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Error running ADB2GEN with a view.
  ADB2PA5.TOKENIZE
  O i=0001696 st=00 Char=ﾽ 4A Sym#=01 N st=00 Act=77 Typ=10
  Ts=0001682
  P=0001696 C
  i=000001696L(sql_stmt)=000001944L(sql_stmt_caps)=000001942
  Syntax error during statement scan. Text= = 'Y'
  ADB2PA5: The following statement could not be parsed :..
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the GEN or DDL line command  *
  *                      on a view, if the default CCSID for     *
  *                      EBCDIC SBCS on the user's system is     *
  *                      different than the CCSID in the         *
  *                      SYSIBM.SYSENVIRONMENT table row for     *
  *                      the view, the DB2 Administration        *
  *                      Tool issues the following error:        *
  *                                                              *
  *                      ADB2PA5: The following statement        *
  *                      could not be parsed :                   *
  *                                                              *
  *                      CREATE VIEW >schema<.>view_name<...     *
  *                          SELECT ALL ...,                     *
  *                                ...                           *
  *                            FROM ...                          *
  *                            WHERE ...                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the GEN or DDL line command on a view, if the
  default CCSID for EBCDIC SBCS on the user's system is
  different than the CCSID in the SYSIBM.SYSENVIRONMENT table
  row for the view, the DB2 Administration Tool issues the
  following error:
  
  ADB2PA5: The following statement could not be parsed :
  
  CREATE VIEW >schema<.>view_name<...
      SELECT ALL ...,
            ...
        FROM ...
        WHERE ...
  

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:

Modules/Macros

• ADB2PA   ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI14219

     UP14/01/16 P F401

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.