PH55143: SQL STATEMENT IS GENERATED WITH A LONG STRING LITERAL TRUNCATED TO 4000 CHARACTERS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQL supports a string literal up to 32704 characters. However,
  Admin Tool has an internal limit of 4000. This will be increased
   to 32704.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who generate DDL statements that have        *
  *                 character constants larger than 4000         *
  *                 characters                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When formatting a generated DDL         *
  *                      statement, only the first 4000          *
  *                      characters of large character constants *
  *                      are written.                            *
  ****************************************************************
  An internal limit caused large character constants to be
  truncated at 4000 characters when formatting DDL for output.
  This limit has been removed. As a result, character constants up
  to the maximum size of 32,704 are now properly formatted for
  output.
  

Problem conclusion

• The 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:

  UI93141 UI93142

Modules/Macros

• ADB2FMM  ADB2FMP  ADB2FMT  ADB2REG  ADB2REH
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI93141

     UP23/08/15 P F308

• RD10 PSY UI93142

     UP23/08/15 P F308

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.