MQSeries.net :: View topic - XMLNSC parshing

scravr · Posted: Wed Oct 31, 2007 3:52 pm Post subject:

HI Everyone:

Using XMLNSC, I encountered WBI XSD parsing problems when element is empty, like: <counter/> the parser passed value of previous element.

On both MqInput and Compute nodes: I checked ALL XMLNSC parsher options.

This is a code sample: It takes the values form input XML and assign to DB-fields:

DECLARE NS1 NAMESPACE 'http://www.nyc.ny.gov/enterprise';

DECLARE ED REFERENCE TO InputRoot.XMLNSC.NS1:EnterpriseDatashareDocument;

DECLARE DH REFERENCE TO InputRoot.XMLNSC.NS1:EnterpriseDatashareDocument.NS1:DocumentHeader;

DECLARE DBH REFERENCE TO DH.NS1:DocumentBusinessHeader;

DECLARE DB REFERENCE TO InputRoot.XMLNSC.NS1:EnterpriseDatashareDocument.NS1:DocumentBody;

INSERT INTO Database.dbo.ImportXML2 (

timestamp

, DocumentPostDate

, DocumentPostTime

, count

, seqno

, linecount

, batch)

VALUES (

DBH.timestamp

, DBH.DocumentPostDate

, DBH.DocumentPostTime

, DBH.count

, DBH.seqno

, DBH.linecount

, DBH.batch);

This is the XML sample:

<e:EnterpriseDatashareDocument xmlns:e="http://www.nyc.ny.gov/enterprise"><e:DocumentHeader><e:DocumentServiceID>DOITT_311_push_1</e:DocumentServiceID><e:DocumentBusinessHeader><timestamp>2007-10-26 15:14:37</timestamp><DocumentPostDate>2007-10-26</DocumentPostDate><DocumentPostTime>15:14:35</DocumentPostTime><count/> <seqno/><batch/><linecount/><filename/><sendtime/><header/><headerLine/><AGENCYDATA><CSMSSRNUMBER>1-1-113665414</CSMSSRNUMBER> â€¦ â€¦ â€¦â€¦..

In this case ALL empty elements (starting count) are getting value of 15:14:35 (as for DocumentPostTime).

What do I need to do in order to get SPACES for empty elements?

HELP ! HELP ! HELP !

Thank you,

Moshe