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

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