SEO

#1 (**permalink**) 02-27-2008, 08:18 AM

xquery
for $y in
db2-fn:xmlcolumn('MYTABLE.DATAXML')/DataXML/MLData/Gr/LongDescription
return $y

Works fine if LongDescription contains only english... if I use greek
for example.. I get

SQL0969N There is no message text corresponding to SQL error "-20412"
in the
message file on this workstation. The error was returned from module
"SQLABOLB" with original tokens "". SQLSTATE=2200W

SQL10007N Message "20412" could not be retrieved. Reason code: "4".

SQLSTATE 2200W: An XML value contained data that could not be
serialized.

Any help would be great!

Vasili

#2 (**permalink**) 02-27-2008, 08:27 AM

Vasili,

are you running the query from the command line? If yes, you get this
error because Double Byte Character Set is not supported for the
command line mode.

If you run the query from the DB2 Developer Workbench or Control
Center, you should be able to see the correct output.

Vitor

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

DB2 XQUERY can't serialize unicode string??? STATE 2200W