Re: XML DB2 Extender help

What is the actual document you are trying to parse? Note you shouldn't
really be parsing the DTD and instead parsing an "instance" of the DTD which
will be a .xml file of some sort.

For example, the XML should look something like this:

<SRSReturn>
<DataArea>
<storeNumber></storeNumber>
<transDate></transDate>
...
</DataArea>
</SRSReturn>

With all of this said, I haven't used the DB2 XML Extender in years.

Aaron Bartell
http://mowyourlawn.com

On Tue, Oct 28, 2008 at 9:43 AM, Sharon <sklosinski@xxxxxxxxxxx> wrote:

Good morning all, I am learning the DB2 Extender by myself at my company
and need some help.

I
have supplied DTD's from our new Vendor and am trying to enable a
collection with the DAD file I created to break out and pull in data.
I have created test files to house this data until we know what data
will go where.

When I try to enable the collection the return message is giving back this
message:

DXXQ047E Parser error on line 10 column 12: Expected an attribute name

Here is some of the supplied DTD, the entire chunk of data comes in a
DataArea, then is broken out:

<!ELEMENT SRSReturn (DataArea)>
<!ATTLIST SRSReturn version CDATA #FIXED "1.0">
<!ELEMENT
DataArea

(storeNumber?,transDate?,localTransactionNumber?,centralTransactionNumber?,Status?,AssociateID?,refundPolicy?,TotalCredit?,ConversionCredit?,Customer?,Item*,ReturnPaymentInfo*,
ReturnMsg?) >
<!ELEMENT storeNumber (#PCDATA)>
<!ELEMENT transDate (#PCDATA)>
<!ELEMENT localTransactionNumber (#PCDATA)>
<!ELEMENT centralTransactionNumber (#PCDATA)>
<!ELEMENT Status (#PCDATA)>
<!ELEMENT AssociateID (#PCDATA)>
<!ELEMENT refundPolicy (#PCDATA)>
<!ELEMENT TotalCredit (#PCDATA)>
<!ELEMENT ConversionCredit (#PCDATA)>
<!ELEMENT Customer (CustomerID?,FirstName?,LastName?) >

Here is some of my DAD:


<?xml version="1.0"?>
<!DOCTYPE DAD SYSTEM "sstrippoli\dtd\dad.dtd">
<DAD>
<Xcollection>
<prolog>?xml version="1.0"?</prolog>
<doctype>!DOCTYPE Order SYSTEM "/sstrippoli/dtd/SRSReturns.dtd"</doctype>
<root_node>
<element_node name="DataArea">
<RBD_node>
<table_name="header_test"/>
<table_name="paym_test"/>
<table_name="item_test"/>
<condition>header_test.cnttrnno=item_test.cnttrnno AND item_test.cnttrnno=
paym__test.cnttrnno</condition>
</RBD_node>
<element_node name="storenumber">
<text_node>
<RBD_node>
<table_name="header_test">
<column_name="strno">
</RBD_node>
</text_node>
</element_node>
<element_node name="transdate">
<text_node>
<RBD_node>
<table_name="header_test">
<column_name="trandate">
</RBD_node> . . . . .

If
someone could please tell me what I am missing and why, have been
agonizing over Redbooks for weeks, need to move along with this very
soon. Any help would be appreciated.

Thanks.

Sharon