A fix is available
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 number
PM15413
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-05-27
Closed date
2010-06-10
Last modified date
2010-07-01
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 July 2010