Hi All,
I am creating a XML file using XML Output Stage.
The Output XML file is successfully getting created in path mentioned in "Stage\Options" tab of XML Output Stage.
The value given currently in this tab is something like
"/data/ds/server1/targets/sampleout.xml"
I would like to parameterize the Unix Path where XML file is getting generated.
The Expected value is something like "#prmTargets#/sampleout.xml"
There is no facility of adding parameter in "Stage\Options" tab.
Does anyone know how to give parameter for filepath in XML output stage?
Thanks in advance.
Parameter for XML Output File Path
Moderators: chulett, rschirm, roy
The proprety for the filename is just a string, and like most blank string properties of that type in DS, you can use a Job Parameter freely.
However, unless you are "bursting" your output into many smaller documents based on some key value (XMLOutput does this automatically if desired), I would recommend that you send the resulting xml to a follow-on downstream Stage. Do this by adding an output link, and then in that output link, have one single column. Give it any name, such as myXMLContent, a longvarchar datatype and some length, like 999999. Put a single '/' in the Description.
Now you have a single column containing your complete xml document. You can send this to a Sequential stage with no formatting ("none" for quotes and delimieter) to write it to a file, or to a column in an rdbms table, or to a message queue, etc..... your XMLOutput Stage will always remain the same.
Ernie
However, unless you are "bursting" your output into many smaller documents based on some key value (XMLOutput does this automatically if desired), I would recommend that you send the resulting xml to a follow-on downstream Stage. Do this by adding an output link, and then in that output link, have one single column. Give it any name, such as myXMLContent, a longvarchar datatype and some length, like 999999. Put a single '/' in the Description.
Now you have a single column containing your complete xml document. You can send this to a Sequential stage with no formatting ("none" for quotes and delimieter) to write it to a file, or to a column in an rdbms table, or to a message queue, etc..... your XMLOutput Stage will always remain the same.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>