Hi all,
I wrote a XML job in XML Pack 1.0 that works fine, Import it in XML Pack 2 trying to use XML output stage but it doesn't work.
In Input i have Oracle tables then a transformer and finally the XML output stage.
This i swhat i want in output :
<lettrages>
<lettrage>
<action>L</action>
<numfacture>878915</numfacture>
<codeLettrage/>
<dateLettrage>2005-07-22</dateLettrage>
</lettrage>
<lettrage>
<action>D</action>
<numfacture>1017965</numfacture>
<codeLettrage/>
<dateLettrage>2005-08-16</dateLettrage>
</lettrage>
</lettrages>
In the transformer,
- the columns are varchar or decimal
- no keys
- Descriptions are /lettrages/lettrage/action/text() for varchars and /lettrages/lettrage/numfacture for decimal
The error message is :
LettrageEBSSeafretTest..XML_Output_32: Xalan error (publicId: , systemId: d:/ardent/interfaces/data/Let2.xml, line: 1, column: 820796): Unknown element 'numfacture' (for each column)
So i've tried to change the Data element to string or number or XML.
Doesn't work !
Someone have an idea ?
Merci.
XML Output Stage
Moderators: chulett, rschirm, roy
Hi and Welcome aboard ,
Congratulations on your first post/solution here
Congratulations on your first post/solution here
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org