Informix - Problem description
Problem IT14735 | Status: Closed |
INVALID XML CREATED BY GENXMLQUERYHDR(), GENXMLQUERYHDRCLOB() AND GENXMLSCHEMA()/GENXMLSCHEMACLOB() FUNCTIONS | |
product: | |
INFORMIX SERVER / 5725A3900 / B50 - IDS 11.50 | |
Problem description: | |
The output of genxmlqueryhdr()/genxmlqueryhdrclob() is not digestible by a XML consuming UDR like extract() or idsxmlparse(). First problem is that the encoding specification is done in an invalid format. Essentially what's used here seems to be the CLIENT_LOCALE value (or its default en_us.819 if CLIENT_LOCALE isn't used). But also the second line added, , seems to cause a parsing error, possibly because there's no closing and because this is placed outside the documents root. This might also be the problem with genxmlschema[clob](): this XML inlined schema doesn't seem to be valid. Moreover it's unclear whether extract() and idsxmlparse() would really use such a schema for validation. select genxmlqueryhdr('customer', 'select * from customer where customer_num=102') from sysmaster:sysdual; (expression) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * production environment * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.50.xC10 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.04.2016 15.06.2017 15.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.50.xC10 | |
Problem solved according to the fixlist(s) of the following version(s) |