Help with XMLOutput Stage

[Nagaraj]

Even after reading your resply i cudnt figure out what is the error?

xpath statement ???

can you give an example?

for example
i have
col1 col2
123 abc

how to define xpath for col1 and col2?

thanks

[chulett]

Split from this post, if anyone is wondering who the "you" and "your" that is being referred to is.

viewtopic.php?p=392214

Nagaraj - Please explain your issue and job design and we'll see what we can do to get your particular issue solved. Also please edit your post to add your particulars - Job type, O/S, version.

[kcho69]

Dear Nagaraj:

Suppose you need to create a xml document like this:

<MyXML>
<MyColumns>
<col1>123</col1>
<col2>abc</abc>
</MyColumns>
</MyXML>

You must use xpath statements to indicate to corresponding stage (e.g: XMLOutput or XMLWriter) how this columns are arranged, so in this example you should set:

name type length description
col1 integer 10 /MyXML/MyColumns/col1
col2 varchar 255 /MyXML/MyColumns/col2


In case you use XMLWriter, you must omit specified the root element (MyXML in this case) since this value must be set in the properties of the stage.


Regards
Diego