MQSeries.net :: View topic

LH33 · Posted: Thu Oct 30, 2003 1:18 pm Post subject:

I have a message flow that takes an input XML transaction and checks certain tags for values (bolded tags below). If the tags have values, I need to let them go to the outputroot unchanged. If the tags are not there, then I need to create an empty tag for the output root. My problem is that the tags are indexed. Can someone help me understand how to get my expected results shown below. I have included the input XML and what the desired XMl result should be. Thanks!! Lisa

Input XML when the tags are present:

<ChangeJob revision="1.0.0" environment="Test">
<DataArea>
<Change confirm="Always" fieldid="1"/>
<Job>
<Location>
<Address>
<Streets>
<Street index="1">
<Article>N</Article>
<Direction>NE</Direction>
<Type>AV</Type>
<Name>F 301 N PULASKI ST</Name>
</Street>
<Street index="2">
<Article>E</Article>
<Direction>E</Direction>
<Type>AV</Type>
<Name>N 222 Main street</Name>
</Street>
</Streets>
</Address>
</Location>
</Job>
</DataArea>
</ChangeJob>

Here is the XML when the tags are not present:

<ChangeJob revision="1.0.0" environment="Test">
<DataArea>
<Change confirm="Always" fieldid="1"/>
<Job>
<Location>
<Address>
</Address>
</Location>
</Job>
</DataArea>
</ChangeJob>

Here is the desired XML output when the input tags are missing:
<ChangeJob revision="1.0.0" environment="Test">
<DataArea>
<Change confirm="Always" fieldid="1"/>
<Job>
<Location>
<Address>
<Streets>
<Street index="1">
<Article></Article>
<Direction></Direction>
<Type></Type>
<Name></Name>
</Street>
<Street index="2">
<Article></Article>
<Direction></Direction>
<Type></Type>
<Name></Name>
</Street>
</Streets>
</Address>
</Location>
</Job>
</DataArea>
</ChangeJob>

Here is my current code:

DECLARE STREET1 CHAR;
SET STREET1 = THE ( SELECT ITEM R FROM InputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.[]
as R where R.(XML.Attribute)index = '1');

DECLARE STREET2 CHAR;
SET STREET2 = THE ( SELECT ITEM R FROM InputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.[]
as R where R.(XML.Attribute)index = '2');

DECLARE ARTICLE1 CHAR;
SET ARTICLE1 = THE ( SELECT ITEM R FROM InputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Article[]
as R where R.(XML.Attribute)index = '1');

DECLARE ARTICLE2 CHAR;
SET ARTICLE2 = THE ( SELECT ITEM R FROM InputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Article[]
as R where R.(XML.Attribute)index = '2');

DECLARE DIRECTION1 CHAR;
SET DIRECTION1 = THE ( SELECT ITEM R FROM InputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Direction[]
as R where R.(XML.Attribute)index = '1');

DECLARE DIRECTION2 CHAR;
SET DIRECTION2 = THE ( SELECT ITEM R FROM InputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Direction[]
as R where R.(XML.Attribute)index = '2');

DECLARE TYPE1 CHAR;
SET TYPE1 = THE ( SELECT ITEM R FROM InputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Type[]
as R where R.(XML.Attribute)index = '1');

DECLARE TYPE2 CHAR;
SET TYPE2 = THE ( SELECT ITEM R FROM InputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Type[]
as R where R.(XML.Attribute)index = '2');

IF STREET1 IS NULL or STREET1 < ' ' THEN
CREATE FIELD OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street[1];
SET OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street[1].(XML.Attribute)index=1;

IF ARTICLE1 IS NULL or ARTICLE1 < ' ' THEN CREATE FIELD OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Article;
SET OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Article[1].(XML.Attribute)index=1;

IF DIRECTION1 IS NULL or DIRECTION1 < ' ' THEN
CREATE FIELD OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Direction;
SET OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Direction[1].(XML.Attribute)index=1;

IF TYPE1 IS NULL or TYPE1 < ' ' THEN
CREATE FIELD OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Type;
SET OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Type[1].(XML.Attribute)index=1;
END IF;
END IF;
END IF;
END IF;

IF STREET2 IS NULL or STREET2 < ' ' THEN
CREATE FIELD OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street[2];
SET OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street[2].(XML.Attribute)index=2;

IF ARTICLE2 IS NULL or ARTICLE2 < ' ' THEN
CREATE FIELD OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Article;
SET OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Article[2].(XML.Attribute)index=2;

IF DIRECTION2 IS NULL or DIRECTION2 < ' ' THEN
CREATE FIELD OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Direction;
SET OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Direction[2].(XML.Attribute)index=2;

IF TYPE2 IS NULL or TYPE2 < ' ' THEN
CREATE FIELD OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Type;
SET OutputRoot.XML.ChangeJob.DataArea.Job.Location.Address.Streets.Street.Type[2].(XML.Attribute)index=2;
END IF;
END IF;
END IF;
END IF;
END IF;

Here is the output when I run this code:

<ChangeJob revision="1.0.0" environment="Test">
<DataArea>
<Change confirm="Always" fieldid="1"/>
<Job>
<Location>
<Address>
<Streets>
<Street index="1">
<Name></Name>
<Article index="1"/>
<Article index="2"/>
<Direction index="1"/>
<Direction index="2"/>
<Type index="1"/>
<Type index="2"/>
</Street>
<Street index="2"/>
</Streets>
</Address>
</Location>
</Job>
</DataArea>
</ChangeJob>

Thanks for any help!!