PK98387: SQLCODE113 WRONGLY ISSUED DURING XML-SCHEMA VALIDATION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLcode113 wrongly issued during XML-Schema
  validation
  .
  During parsing XML document with xmlvalidate a SQLcode113 is
  issued.  DSN_XMLVALIDATE is called in a COBOL application.
  This happend after PK66532 was applied, but the SCHEMA is
  valid an doesn't contain invalid characters.
  It contains trailing blanks.
  .
  After changing data type of XML-SCHEMA in COBOL application
  from CHAR(80) into VARCHAR(80) the SQLcode113 disappeared.
  .
  We're asuming that the trailing blanks in connection with
  the change introduced with PK66532 is  causing the error.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the following XSR routines:         *
  *                 SYSPROC.XSR_REGISTER                         *
  *                 SYSPROC.XSR_ADDSCHEMADOC                     *
  *                 SYSPROC.XSR_REMOVE                           *
  *                 SYSPROC.XSR_COMPLETE                         *
  *                 SYSPROC.XDBDECOMPXML                         *
  *                 SYSFUN.DSN_XMLVALIDATE                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When users specified XSR Schema name    *
  *                      string with trailing blanks/white-      *
  *                      spaces, SQLCODE -113 occurred.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The trailing blanks on the XSR schema name string are evaluated
  as invalid characters on an undelimited string. This results
  in the SQLCODE -113 being issued.
  

Problem conclusion

• Trailing blanks on an undelimited XSR Schema name are treated
  to be unsignificant and stripped off before the name is
  evaluated.
  

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:

  UK53293

Modules/Macros

• DSN@VDCP DSN@VVAL DSN@VXAD DSN@VXCM DSN@VXRG
  DSN@VXRM DSNNVDCP DSNNVVAL DSNNVXAD DSNNVXIN DSNNVXRG DSNNVXRM
  DSNX9SPJ
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK53293

     UP10/01/26 P F001

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.