MQSeries.net :: View topic

KIT_INC · Posted: Mon Mar 29, 2010 7:40 am Post subject:

I am using Broker V61 on windows. I have to create an XML output from a field in the XML input message.

The INput message is like
<?xml version="1.0" encoding="UTF-8"?>
<CCWEB DocVersion="4.0" Created="03/1/2010 8:51:44 AM" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns="x-schema:CCWEBSchema.xml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="x-schema:CCWEBSchema.xml C:\DOCUME~1\CCWEB.xsd">
<Categories>
<Category CategoryID="1000001" Name="HOTEL SERVICE" />
</Categories>
</CCWEB>

The flow is a simple MQINPUT-TRACE-COMPUTE-MQOUTPUT
The Input is just using XMLNS because I have no schema.

My ESQL is like
DECLARE SP1 NAMESPACE 'x-schema:CCWEBSchema.xml';
SET OutputRoot.XMLNS.NS_TEST.DATA=InputRoot.XMLNS.SP1:CCWEB.SP1:Categories.SP1:Category.Name;

This works and the output looks like
<NS_TEST DATA="HOTEL SERVICE"/>

But my ESQL has to know the NAMESPACE ahead of time. Can I get the namespace dynamically from Input?

I am new to Namespace. I am not sure if I am asking stupid question. If I am right the namspace comes from the XML decl of the incoming message. But I have a hard trying to figure out how to pick up the Namespace information from InputRoot.XMLNS
Looking at the trace output, the root element is already qualified with the NS (x-schema:CCWEBSchema.xml:CCWEB ).

Is the Input data correct ? If so, am I asking for something not normal practice?

This is what shows in the TRACE
(0x01000010:ParserRoot):XMLNS = ( ['xmlns' : 0x771a4b8]
(0x05000018:XmlDecl ):XML = (
(0x06000011:Version ): = '1.0' (CHARACTER)
(0x06000012:Encoding): = 'UTF-8' (CHARACTER)
)
(0x06000002:WhiteSpace): = '
' (CHARACTER)
(0x01000000:Element )x-schema:CCWEBSchema.xml:CCWEB = (
(0x03000000:Attribute ):DocVersion = '4.0' (CHARACTER)
(0x03000000:Attribute ):Created = '12/1/2009 8:51:44 AM' (CHARACTER)
(0x07000012:NamespaceDecl)xmlns:msxsl = 'urn:schemas-microsoft-com:xslt' (CHARACTER)
(0x07000012:NamespaceDecl):xmlns = 'x-schema:CCWEBSchema.xml' (CHARACTER)
(0x07000012:NamespaceDecl)xmlns:xsi = 'http://www.w3.org/2001/XMLSchema-instance' (CHARACTER)
(0x03000000:Attribute )http://www.w3.org/2001/XMLSchema-instance:schemaLocation = 'x-schema:CCWEBSchema.xml C:\DOCUME~1\CCWEB.xsd' (CHARACTER)
(0x02000000:pcdata ): = '
' (CHARACTER)
(0x01000000:Element )x-schema:CCWEBSchema.xml:Categories = (
(0x02000000:pcdata ): = '
' (CHARACTER)
(0x01000000:Element)x-schema:CCWEBSchema.xml:Category = (
(0x03000000:Attribute):CategoryID = '1000001' (CHARACTER)
(0x03000000:Attribute):Name = 'HOTEL SERVICE' (CHARACTER)
)
(0x02000000:pcdata ): = '
' (CHARACTER)
)
(0x02000000:pcdata ): = '
' (CHARACTER)
)
)
);