Re: XML DB2 Extender help

Hello, thank you for your interest in my problem.

I did hear from someone at IBM who I also sent this email, seems I had syntax errors in the DAD file, using 'table_name' instead of 'table name', same with column name, etc.

I did get those corrected and tried the GENX command against it and now I have this message:

'DXXQ013E The table or column element does not have a name in the DAD file'

So I will be checking my spelling against my DAD and the supplied DTD from the vendor for the field names. I also will check that I am listing the files correctly at the top of my DAD file.

Thanks.

To: wdsci-l@xxxxxxxxxxxx
From: ravn@xxxxxxxxxx
Date: Tue, 28 Oct 2008 20:16:07 +0100
Subject: Re: [WDSCI-L] XML DB2 Extender help

Sharon skrev:

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>

And the SRSReturns.dtd is the above file?

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.

Please provide a complete DTD and a complete DAD file showing the
behaviour. I suspect that the <!ELEMENT line must have its name right
after instead of on the next line but it is hard to say with snippets.
--
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.

_________________________________________________________________
Want to read Hotmail messages in Outlook? The Wordsmiths show you how.
http://windowslive.com/connect/post/wedowindowslive.spaces.live.com-Blog-cns!20EE04FBC541789!167.entry?ocid=TXT_TAGLM_WL_hotmail_092008