PM15413: SQLCODE113 WHEN RUNNING "SET CURRENT PATH = MY_PATH" WHEN THE PATH NAME CONTAINS AN UNDERSCORE AND IS NOT DELIMITED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE -113 (SQLCODE113) when issuing the following SQL:
  SET CURRENT PATH = MY_PATH ;
  The underscore is not recognized as a valid character for the
  schema name, but it is a valid character for schema names.
  

Local fix

• Delimit the path name as "MY_PATH" as a workaround.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the SET PATH statement in DB2 UDB   *
  *                 for z/OS Version 8.1 or DB2 Version 9.1 for  *
  *                 z/OS                                810 910  *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 returns SQLCODE113 erroneously when *
  *                      an ordinary SQL identifier for a        *
  *                      schema-name on the right-hand side of   *
  *                      the SET PATH statement contains an      *
  *                      underscore character.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  For example, DB2 issues SQLCODE -113 for the following valid SQL
  statement where A_B is an ordinary SQL identifier specifying a
  schema-name:
  
  SET PATH = A_B;
  
  The error issued is as follows:
  
  SQLCODE = -113, ERROR:  INVALID CHARACTER FOUND IN: A_B.
                          REASON CODE 000
  SQLSTATE   = 42602 SQLSTATE RETURN CODE
  SQLERRP    = DSNHSMUD SQL PROCEDURE DETECTING ERROR
  SQLERRD    = 31  0  0  -1  12  809 SQL DIAGNOSTIC INFORMATION
  
  A schema-name used in a SET PATH statement may be any valid
  SQL identifier, and thus may contain an underscore character
  when the identifier is not delimited.
  

Problem conclusion

• DB2 code is modified so that a schema-name used in a SET PATH
  statement may be specified using an ordinary SQL identifier
  which contains the underscore character.
  

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:

  UK57865 UK57866

Modules/Macros

• DSNHSMF1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK57865

     UP10/06/25 P F006

• R910 PSY UK57866

     UP10/06/25 P F006

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.