Professional Web Applications Themes

DB2 XML EXTENDER - IBM DB2

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: p err 10 in file C:\temp\dxx11 line 26301 col 49: DXXQ047E Pr 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. Thanks for yours replies....

  1. #1

    Default DB2 XML EXTENDER

    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:

    p err 10 in file C:\temp\dxx11 line 26301 col 49: DXXQ047E Pr 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.

    Thanks for yours replies.





    Silvano Attolini Guest

  2. #2

    Default Re: DB2 XML EXTENDER

    Hello,

    I belive that CLOB the limit is 1MB. Check the Appendix D of the XML
    Extender Admin Guide.

    [url]ftp://ftp.software.ibm.com/ps/products/db2/info/vr7/pdf/letter/db2sxe70.pdf[/url]

    There's a link on increasing the CLOB limit at the bottom of the page.

    Kind regards,
    Eric

    Silvano Attolini 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:
    >
    > p err 10 in file C:\temp\dxx11 line 26301 col 49: DXXQ047E Pr 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.
    >
    > Thanks for yours replies.
    >
    >
    >
    >
    >
    Eric Sirois Guest

  3. #3

    Default Re: DB2 XML EXTENDER

    Silvano Attolini wrote:
    > 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.
    Telling DB2 that the compiled function can handle larger chunks of data
    doesn't change the behavior of the object code which gets called!

    Or, am I missing something here?

    > "Eric Sirois" <esiroisREMOVESPAMFILTERca.ibm.com> ha scritto nel messaggio
    > news:bf9h5c$4vu$1hanover.torolab.ibm.com...
    >
    >>Hello,
    >>
    >>I belive that CLOB the limit is 1MB. Check the Appendix D of the XML
    >>Extender Admin Guide.
    Steven N. Hirsch Guest

Similar Threads

  1. Values not persisting in extender provider
    By *no spam* in forum ASP.NET Building Controls
    Replies: 5
    Last Post: October 31st, 12:47 PM
  2. Replies: 0
    Last Post: August 22nd, 12:58 PM
  3. Replies: 0
    Last Post: August 1st, 03:23 PM
  4. Text Extender
    By Stanley Sinclair in forum IBM DB2
    Replies: 0
    Last Post: July 5th, 08:56 PM
  5. Xml extender question
    By Roberto Finelli in forum IBM DB2
    Replies: 0
    Last Post: June 27th, 10:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139