PM94433: EXPECTED EXCLAMATION POINT ! INCORRECT IN QMF GENERATED EXPORT DATA TO DATASET WITH DATAFORMAT=XML

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Running QMF EXPORT DATA to dataset with DATAFORMAT=XML
  The QMF generated XML file incorrectly has a square bracket ']'
  instead of the expected exclamation point '!'.
  For example the following incorrectly generated lines:
  
  <?xml version="1.0" encoding="utf-8"?>
    <]-- A style sheet has been provided ...
  
  The line should have an exclamation point as follows:
  
  <?xml version="1.0" encoding="utf-8"?>
    <!-- A style sheet has been provided ...
  
  The resultant file cannot be viewed with the native Windows XML
  editor.
  The file can be opened in NOTEPAD and the occurances of ] can be
  replaced with !
  

Local fix

• The resultant file cannot be viewed with the native Windows XML
  editor.
  The file can be opened in NOTEPAD and the occurances of ] can be
  replaced with !
  *
  The fix for this APAR removes the informational
  spill file messages:
  DSQCSIDT:open spill
  and
  CLOSE SPILLFILE: NO ERROR CSIDT INFO
  *
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V9 to V11 users who     *
  *                 export data in XML format.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Problem 1:                              *
  *                      The XML comment character in the        *
  *                      exported file was not the expected      *
  *                      character.  When CCSID 1148             *
  *                      (DSNHDECP SCCSID=1148) is used, the     *
  *                      comment character in UTF-8 was x'5D'    *
  *                      (right bracket -  ) instead of the      *
  *                      expected x'21' (exclamation point - !). *
  *                                                              *
  *                      Problem 2:                              *
  *                      Users can also receive SQLCODE -20400   *
  *                      "Error resolving component 'integer'."  *
  *                      when trying to register a schema in     *
  *                      XSR on DB2.                             *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Problem 1:
  The comment character was being incorrectly defined and
  translated.
  
  Problem 2:
  The "type=" value for integer in *.SDSQSAPn(DSQ1SCEM) was
  missing the "xs:" identifier.
  

Problem conclusion

• Problem 1:
  QMF code has been changed to translate the XML tags that QMF
  creates using code page 037, as distinct from the data from the
  database, which will be translated with the DB2 codepage stored
  in CVSCPDBM.
  
  Problem 2:
  *.SDSQSAPn(DSQ1SCEM) has been corrected to include the xs: in
  the type definition for integer.
  (type="xs:integer"/>)
  
  Additional enhancement:
  Some automatically generated trace records for DSQSPILL file
  normal open and close activity have been deactivated.
  

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:

  UI12052 UI12053 UI12054

Modules/Macros

• DSQCELTT DSQCFIDC DSQCRSNC DSQCSIDT DSQCUNIC DSQDEXML DSQPNLE
  DSQ1SCEM
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UI12052

     UP13/11/03 P F311

• RB10 PSY UI12053

     UP13/11/03 P F311

• R910 PSY UI12054

     UP13/11/03 P F311

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.