Prev: Can DB2_ALL get any easier ?
Next: FYI: DB2 9.7.2 eGA with more SQL goodies to get off Oracle
From: Frederik Engelen on 29 May 2010 07:20
On 28 mei, 22:32, brunoalsantos <brunoalsan...(a)gmail.com> wrote:
> On 28 maio, 17:02, Tonkuma <tonk...(a)fiberbit.net> wrote:
>
> > What data type in the XMLSERIALIZE did you specified?
>
> > Was that still too long?
> > For example: CLOB.
> > (Default for CLOB is CLOB(1M). )
>
> > How about something like VARCHAR(1000)?
>
> I specified CLOB ..
>
> My statement ..
>
> select
> XMLSERIALIZE(
>    XMLGROUP(
>       T.MACHINE_ID,
>       D.DEPARTMENT_NAME,
>       T.MACHINE_HOSTNAME
>    OPTION ROOT "desktop") AS CLOB (50M))
>
> FROM
> ASSET.TBL_ASSET_MACHINE_ID T
> INNER JOIN ASSET.TBL_ASSET_DEPARTMENT D ON (T.DEPARTMENT_ID =
> D.DEPARTMENT_ID)
>
> ;
>
> Result on CLP ..
>
> .....
> NAME>BSARO1-006</MACHINE_HOSTNAME></
> row><row><MACHINE_ID>0001023C44E759AF89131534</
> MACHINE_ID><DEPARTMENT_NAME>RIO</
> DEPARTMENT_NAME><MACHINE_HOSTNAME>RBOMR1-005</MACHINE_HOSTNAME></row>
> DB29320W  Output has been truncated.
>
> Thanks.

Hello Bruno,

The message you're seeing is coming from the DB2 CLP (client), not
from the server itself. Could you use another client to retrieve the
same string? In the past, I used Java to export such large XML
documents from DB2.

Off topic: if you want some fun, try Groovy, you'll love it.

--
Frederik Engelen



First  |  Prev  | 
Pages: 1 2
Prev: Can DB2_ALL get any easier ?
Next: FYI: DB2 9.7.2 eGA with more SQL goodies to get off Oracle