Hi,

I'm trying to load a XML file into a table DB2 (Version 7.2) with XML
Extender.
It work fine if my file have a dimension 1K

But if my file have bigger dimension (12 M ) I get this error message:

parse err 10 in file C:\temp\dxx11 line 26301 col 49: DXXQ047E Parser error
on
line 26301 column 49: Expected end of tag 'CodiceClienteCapogruppo'

My xml file is valid (I'm sure), but load fail.

This is my command:
"C:\dxx\bin\shred.exe" DBNAME filename.dad "C:\temp\filename.xml"

I work on PC with Win2000.

I have increased the CLOB limit in dxxShredXML and dxxInsertXML following
this steps:

1) db2 DROP PROCEDURE db2xml.dxxShredXML


2) db2 create procedure db2xml.dxxShredXML( in dadBuf Clob(100K),

in XMLObj Clob(20M),

out returnCode integer,

out returnMsg varchar(1024))
external name 'db2xml!dxxShredXML'
language C
parameter style DB2DARI
not deterministic
fenced
null call;


but we have same results.

Silvano Attolini <sa@multidatagroup.it> wrote:

> Hi,
>
> I'm trying to load a XML file into a table DB2 (Version 7.2) with XML
> Extender.
> It work fine if my file have a dimension 1K
>
> But if my file have bigger dimension (12 M ) I get this error message:
>
> parse err 10 in file C:\temp\dxx11 line 26301 col 49: DXXQ047E Parser
> error on
> line 26301 column 49: Expected end of tag 'CodiceClienteCapogruppo'
>
> My xml file is valid (I'm sure), but load fail.

Well, what is on line 26301 in your file?
Where is the opening tag <CodiceClienteCapogruppo>?
Just a guess, but maybe the nesting of the tags isn't quite right and the
XML Extender parser complains about that whereas your other parser ignored
it?

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

Thanks for your reply,

If we create a new file (dimension < 1M) with an extract of lines around
26301 of the original xml file, the loading work fine.

My xml file is valid (I'm sure).

Maybe the problem is the file dimension.


"Knut Stolze" <stolze@de.ibm.com> ha scritto nel messaggio
news:bfm0dh$m4r$1@fsuj29.rz.uni-jena.de...
> Silvano Attolini <sa@multidatagroup.it> wrote:
>
> > Hi,
> >
> > I'm trying to load a XML file into a table DB2 (Version 7.2) with XML
> > Extender.
> > It work fine if my file have a dimension 1K
> >
> > But if my file have bigger dimension (12 M ) I get this error message:
> >
> > parse err 10 in file C:\temp\dxx11 line 26301 col 49: DXXQ047E Parser>
> error on
> > line 26301 column 49: Expected end of tag 'CodiceClienteCapogruppo'
> >
> > My xml file is valid (I'm sure), but load fail.
>
> Well, what is on line 26301 in your file?
> Where is the opening tag <CodiceClienteCapogruppo>?
> Just a guess, but maybe the nesting of the tags isn't quite right and the
> XML Extender parser complains about that whereas your other parser ignored
> it?
>
> --
> Knut Stolze
> Information Integration
> IBM Germany / University of Jena