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

A fix is available

Subscribe

You can track all active APARs for this component.

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 !
    

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 number

    PM94433

  • Reported component name

    QMF-QUERY MGMT

  • Reported component ID

    566872101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-02

  • Closed date

    2013-10-31

  • Last modified date

    2013-12-02

  • 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 Query Management Facility
QMF for TSO/CICS

Software version:

9.1

Reference #:

PM94433

Modified date:

2013-12-02

Translate my page

Machine Translation

Content navigation