PH10508: DB2 ADMINISTRATION TOOL - GEN PUTS "FOR SBCS DATA" FOR UNICODE COLUMN WHICH IS INVALID SYNTAX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• GEN puts "FOR SBCS DATA" for Unicode column which is invalid
  syntax. Executing the DDL returns SQLCODE -104 / SQLCODEN104:
     SQLCODE = -104, ERROR: ILLEGAL SYMBOL "NOT". SOME SYMBOLS
               THAT MIGHT BE LEGAL ARE: , ) <END-OF-CLAUSE>
  

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.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Reverse Engineering program (ADB2GEN)   *
  *                      erroneously generates "FOR SBCS DATA"   *
  *                      for unicode columns.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When generating a DDL of a table, Reverse Engineering program
  (ADB2GEN) erroneously generates "FOR SBCS DATA" for unicode
  columns. The DDL with invalid syntax will results in SQLCODE=
  -104 / SQLCODEN104 upon the execution.
  
  DSNT408I SQLCODE = -104, ERROR: (ILLEGAL SYMBOL "NOT". SOME
        SYMBOLS THAT MIGHT BE LEGAL ARE: , ) >END-OF-CLAUSE<
  DSNT411I SQLCAID = SQLCAL SQLCA IDENTIFIER
  DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNHSM5 SQL PROCEDURE DETECTING ERROR
  

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:

  UI63598

Modules/Macros

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI63598

     UP19/06/14 P F906

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.