PM47618: ENABLING APAR FOR EMBEDDED XQUERY SUPPORT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Enabling APAR for XQuery support.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users of pureXML.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: This is the enabling APAR for the       *
  *                      embedded XQuery and the constraint      *
  *                      repetition regular expression extension *
  *                      support.                                *
  *                                                              *
  *                      This APAR also fixes following XML      *
  *                      related problems:                       *
  *                      1. SQLCODE -16009 is issued when the    *
  *                         xs:untypedAtomic constructor         *
  *                         function is called.                  *
  *                      2. ABEND04E DSNNXML DSNNOCCN M200       *
  *                         might occur when the XML storage     *
  *                         usage reaches the limit and the      *
  *                         query contains XML publishing        *
  *                         functions or XQuery constructor      *
  *                         functions.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This is the enabling APAR for the embedded XQuery and the
  constraint repetition regular expression extension support.
  
  Below is the list of embedded XQuery features supported in this
  APAR:
  1. FLWOR (For, Let, Where, Order By, Return) expressions
  2. Conditional (if-then-else) expressions
  3. Value comparisons
  4. Node comparisons
  5. XQuery prolog
     Two XQuery prologs are supported:
     a) Boundary-space declaration
     b) Copy-Namespaces Declaration
  6. XQuery constructors
     Following XQuery constructors are supported:
     a) Direct element constructors
     b) Document node constructors
     c) Processing instruction constructors
     d) Comment constructors
  7. Sequence expressions
     Currently only Comma operator is supported.
  8. Castable expressions
  9. fn:avg built-in function
  
  For the constraint repetition regular expression extension
  support, we extend the regular expression support by providing
  constraint repetition quantifiers. We support three constraint
  repetition quantifiers:
  1. {n} matches a pattern exactly n times.
  2. {n,m} matches a pattern at least n times but not more than m
     times.
  3. {n,} matches a pattern at least n times.
  
  These embedded XQuery features and the constraint repetition
  regular expression extension can be used in following SQL/XML
  functions:
  1. XMLQUERY
  2. XMLEXISTS
  3. XMLTABLE
  4. XMLMODIFY
  
  Please refer to DB2 10 for z/OS pureXML Guide for the syntax and
  usage detail.
  
  
  For the xs:untypedAtomic constructor function, SQLCODE -16009
  will be issued when the following query is executed.
  
    SELECT XMLQUERY('xs:untypedAtomic(55)') FROM SYSIBM.SYSDUMMY1;
  
  For the ABEND04E DSNNXML DSNNOCCN M200, it can happen when the
  XML storage usage reaches the limit and the query contains XML
  publishing functions or XQuery constructor functions. This
  is caused by the return code not being handled properly. In
  stead of DB2 issuing SQLCODE -904, the ABEND occurs.
  
  Additional keywords: SQLCODE16009 SQLXML
  

Problem conclusion

Temporary fix

Comments

• The embedded XQuery and the constraint repetition regular
  expression extension supports are enabled. Also the XML related
  problems have been fixed.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK73139

Modules/Macros

• DSNNOCCN DSNTIAM  DSNTIA1  DSNXOIDX DSNXOQ1
  DSNXOW2H DSNXQEM  DSNXQFNR DSNXQLEX DSNXQMCH DSNXQNR  DSNXQPRS
  DSNXQREP DSNXQRWA DSNXQRWC DSNXQRWR DSNXQSMT DSNXQSYM DSNXQXPS
  DSNXQXQ2 DSNX5TOP DSNX5TRV DSNX5XEE DSNX5XPD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK73139

     UP11/10/27 P F110

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.