A fix is available
APAR status
Closed as program error.
Error description
Using Rational Application Developer V7.0.0.7 The wizard to extract xml data from a DB2 table fails and produc es an empty XML file and the wizard does not finish or complete the dialog box remains open. This occurs when a table has packed data, non-displayable ASCII characters. When a DB2 table has its columns as CHAR or VARCHAR it works cor rectly the wizard generates the .xml with the table contents in the expected xml format eg: ??xml version='1.0' encoding='UTF-8'?? ?SQLResult? ?CATEGORY NAME='BIRDS'/? ?CATEGORY NAME='CATS'/? ?CATEGORY NAME='DOGS'/? ?CATEGORY NAME='FISH'/? ?CATEGORY NAME='REPTILES'/? ?/SQLResult?
Local fix
Problem summary
In the described scenario, an attempt to export invalid XML characters from a database table into an XML document produced an exception in the execution of the SQL to XML Wizard.
Problem conclusion
The code in the SQL to XML wizard has been modified to address potential exceptions, displaying error messages to the user when applicable. Fix delivered in Rational Application Developer V7.0.0.9
Temporary fix
Comments
APAR Information
APAR number
PK77511
Reported component name
RATL APP DEV WI
Reported component ID
5724J1901
Reported release
750
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-12-15
Closed date
2009-07-17
Last modified date
2009-07-17
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
RATL APP DEV WI
Fixed component ID
5724J1901
Applicable component levels
R750 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSRTLW","label":"Rational Application Developer for WebSphere Software"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
17 July 2009