PM51206: GEN: SQLCODEN713 LOWER CASE CHARACTER IN SCHEMA STATEMENT NOT ENCLOSED IN DOUBLE QUOTES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' GEN function creates DDL
  with lower case character in SCHEMA statement not enclosed in
  in double quotes which results in a SQLCODE -713 when executed.
  

Local fix

• Change the single quotes to double quotes.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) or           *
  *                 Compare function.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      GEN and Compare function create DDL     *
  *                      with lower case characters in a SCHEMA  *
  *                      statement not enclosed in double        *
  *                      quotes, which results in a              *
  *                      SQLCODE=-713 / SQLCODEN713 when         *
  *                      executed:                               *
  *                                                              *
  *                      DSNT408I SQLCODE = -713, ERROR:         *
  *                      THE REPLACEMENT VALUE FOR               *
  *                      CURRENT SCHEMA IS INVALID               *
  *                      DSNT418I SQLSTATE   = 3F000             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS GEN and Compare
  function create DDL with lower case characters in a
  SCHEMA statement not enclosed in double quotes, which
  results in a SQLCODE -713 / SQLCODEN713 when executed:
  
  DSNT408I SQLCODE = -713, ERROR:
  THE REPLACEMENT VALUE FOR CURRENT SCHEMA IS INVALID
  DSNT418I SQLSTATE   = 3F000 SQLSTATE RETURN CODE
  

Problem conclusion

• Programs have been corrected to enclose the schema name in
  double quotes if the schema is not an ordinary identifier.
  (An ordinary identifier is an uppercase letter followed
  by zero or more characters, each of which is an uppercase
  letter, a digit, or the underscore character, and is not
  a reserved word.)
  

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:

  UK77370

Modules/Macros

•    ADBCDTS  ADB2CMF  ADB2CMR  ADB2CMS  ADB2CMT
  ADB2REG  ADB2REH
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK77370

     UP12/03/28 P F203

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.