|
Problem IC75441
|
Status: Closed |
V9.7: IF XML SCHEMA IS USING A ENCODING AMONG SOME SPECIFIC ENCODINGS, REGISTER XMLSCHEMA COMMAND WILL GET SQL16168N RC=7 |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Starting from V9.7, if XML schema is using an encoding other
than listed below, the REGISTER XMLSCHEMA command will get
SQL16168N RC=7.
- ASCII
- UTF-8
- UTF-16 (Big/Small Endian)
- UCS4 (Big/Small Endian)
- EBCDIC code pages IBM037, IBM1047 and IBM1140 encodings
- ISO-8859-1 (aka Latin1)
- Windows-1252
For example, encode.xsd uses Shift_JIS encoding and the
declaration like this.
<?xml version="1.0" encoding="Shift_JIS" standalone="yes"?>
db2 "REGISTER XMLSCHEMA encode.xsd FROM encode.xsd AS
db2xmlschema COMPLETE ENABLE DECOMPOSITION"
SQL16168N XML document contained an invalid XML declaration.
Reason code = "7". SQLSTATE=2200M |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* As same as Error description. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.7 FixPack 5. *
**************************************************************** |
| Local Fix: |
Convert the encoding of the XML files to UTF-8 and remove the
encoding declaration from XSD files. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.03.2011
28.12.2011
28.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
