Re: XML DB2 Extender help

Aaron, yes I am shooting for an xml document with resulting data from my files, just trying to enable the collection. I know when working with collections enabling is not mandatory, so I tried the GENX command to try and generate an xml document from my DAD and DTD, and I still get the same syntax error about the attribute. Just showing the DTD so others could see if I missed something in my DAD related to how the DTD is set up.

Thanks.

Date: Tue, 28 Oct 2008 10:05:06 -0500
From: aaronbartell@xxxxxxxxx
To: wdsci-l@xxxxxxxxxxxx
Subject: Re: [WDSCI-L] 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

--
This is the Websphere Development Studio Client for iSeries (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.

_________________________________________________________________
You live life beyond your PC. So now Windows goes beyond your PC.
http://clk.atdmt.com/MRT/go/115298556/direct/01/