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