XML Output Stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
CLOPES
Participant
Posts: 52
Joined: Tue Jul 22, 2003 8:05 am
Location: France
Contact:

XML Output Stage

Post by CLOPES »

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. :lol:
CLOPES
Participant
Posts: 52
Joined: Tue Jul 22, 2003 8:05 am
Location: France
Contact:

Post by CLOPES »

Ok

I've understood the problem. The "Validate Schema" was checked and i didn't give it.

Sorry.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi and Welcome aboard :),
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
Image
Post Reply