XI 3.0 - JDBC receiver adapter - Need help on formatting the XML

[Former Member]

Hello,

With the DIB I have been able to create a message type with this result (from the mapping test):

<?xml version="1.0" encoding="UTF-8"?>

<root>

<statement1>

<orders>

<access>

<status>F</status>

</access>

<key1>

<ref_number>4444</ref_number>

</key1>

</orders>

</statement1>

</root>

However I need

<?xml version="1.0" encoding="UTF-8"?>

<root>

<statement1>

<orders <u><b>action="UPDATE"</b></u> >

<access>

<status>F</status>

</access>

<key1>

<ref_number>4444</ref_number>

</key1>

</orders>

</statement1>

</root>

How do I get to such a result with "action=UPDATE" in the xml?

Thanks

Boaz

[Former Member]

Hello,

I am not sure I understand what you mean by 'xslt mapping'. I am using the regular message mapping with the mapping editor.

Is there a solution for my problem with the standard DIB tools for creating data types and message types?

Thanks

[Former Member]

Hello,

Thanks.

I solved the problem by defining the object 'action' of type 'attribute in the datatype.

[Former Member]

Hi,

what kind of Mapping do you use? Is it an XSLT-Mapping?

I think you have to create an attribute for the Tag <ORDER>.

In this case you have to type a Statement like this:

<orders>

<xsl:attribute name="action">UPDATE</xsl:attribute>

<xsl:value-of select="ORDERNUMBER"/>

</orders>

If you need a dynamic input use this:

<orders>

<xsl:attribute name="action"><xsl:value-of select="INPUTTYPE"/></xsl:attribute>

<xsl:value-of select="ORDERNUMBER"/>

</orders>

I hope this can help you.