SEO

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

THIS ONLY HAPPENS WHILE QUERYING IN THE CONTROL CENTER. is there anyway
to get around this? the query works fine if I query from java for
example.

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

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

Any help would be great!

Vasili

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

vasilip wrote:
> THIS ONLY HAPPENS WHILE QUERYING IN THE CONTROL CENTER. is there anyway
> to get around this? the query works fine if I query from java for
> example.
Just to get an additional data point:
Have you tried Developer Work Bench (DWB)?

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/

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

No, I havent.. I am downloading it now..

I just went through the tutorial on it while waiting.. seems it will
make my life much easyer.

Thanks for the tip.. as well as for your help in clearing up my
XML/Spatial data table modification issue.

much obliged for your prompt and useful responces.

Vasili

Serge Rielau wrote:
> vasilip wrote:
> > THIS ONLY HAPPENS WHILE QUERYING IN THE CONTROL CENTER. is there anyway
> > to get around this? the query works fine if I query from java for
> > example.
> Just to get an additional data point:
> Have you tried Developer Work Bench (DWB)?
>
> Cheers
> Serge
>
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab
>
> IOD Conference
> http://www.ibm.com/software/data/ond...ness/conf2006/

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

SEO

(CORRECTION!) DB2 XQUERY can't serialize unicode string??? STATE 2200W