IBM Support

PJ38987: Copying a XML Relational Mapping operator will append "_ default schema _" to the column expression of the new operator

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When copying a "XML Relational Mapping" operator, an additional
    tag "_ default schema _"  gets appended to all the column
    expressions in the "Select List" tab of the newly created XML
    Relational Mapping operator.
    
    For example:
    
    If you create a simple flow with Table source + XML Relational
    Mapping + Table target with an expression XMLTABLE.COLUMN1
    defined in "Select List" Tab result columns, Copy and Paste XML
    Relational Mapping operator, the column expression gets changed
    to "_default schema_".XMLTABLE.COLUMN1.
    

Local fix

  • Workaround:None
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When copying a "XML Relational Mapping" operator, an         *
    * additional                                                   *
    * tag "_ default schema _"  gets appended to all the column    *
    * expressions in the "Select List" tab of the newly created    *
    * XML                                                          *
    * Relational Mapping operator.                                 *
    *                                                              *
    * For example:                                                 *
    *                                                              *
    * If you create a simple flow with Table source + XML          *
    * Relational                                                   *
    * Mapping + Table target with an expression XMLTABLE.COLUMN1   *
    * defined in "Select List" Tab result columns, Copy and Paste  *
    * XML                                                          *
    * Relational Mapping operator, the column expression gets      *
    * changed                                                      *
    * to "_default schema_".XMLTABLE.COLUMN1.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to InfoSphere Warehouse 10.1                         *
    ****************************************************************
    

Problem conclusion

  • This problem was first fixed in version 9.7 Fix Pack 1. At a
    minimum, this fixpack should be applied on the client (i.e.
    Design Studio).
    
    After applying this fix, if you copy an "XML Relational Mapping"
    operator in the new XML Relational Mapping operator, it will not
    append "_ default schema _"   to all column expressions.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PJ38987

  • Reported component name

    DWE SQL WHSE TO

  • Reported component ID

    5724DWESQ

  • Reported release

    971

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-13

  • Closed date

    2013-01-07

  • Last modified date

    2013-01-07

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

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

Fix information

  • Fixed component name

    DWE SQL WHSE TO

  • Fixed component ID

    5724DWESQ

Applicable component levels

  • R971 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCMVBH","label":"DWE - SQL Warehousing Tool"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"971","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
07 January 2013