Hi All,
This is the first time i am trying to create a xml file using datastage.
For testing i tried making the following job
txt file ------> Transformer ---------> XML Output stage.
I just gave one column in the input as well as in the XML output stage.
The job ran fine with no errors or warnings, but it did'nt created any file. By error logs also its not clear what went wrong. I am Datastage server edition on Unix.
Can anybody help me solve this.
XML Output stage
Moderators: chulett, rschirm, roy
XML Output stage
Pranay
Seatte, WA
Seatte, WA
The doc is pretty good in this area, so please review it....but in brief, for a simple example, have the input link to your XMLOutput stage put in a couple of columns (let's say a, b, c, d, e) and put the following into the Description attributes of each....
a /myXML/Rows/testRow/@a
b /myXML/Rows/testRow/b/text()
c /myXML/Rows/testRow/c/text()
d /myXML/Rows/testRow/d/text()
e /myXML/Rows/testRow/e/text()
Where the stuff in slashes above is what goes into the Description.
On the output, for testing you can specify a file, although I prefer to send out a single column:
myXMLStuff varchar 999 /
Where it has a single '/' in the Description attribute. Send it to a Sequential Stage and put 000 in the delimter and quote character of the format to get a nice clean XML file.
You have lots to learn about the stages, but this should give you a good start.
Ernie
a /myXML/Rows/testRow/@a
b /myXML/Rows/testRow/b/text()
c /myXML/Rows/testRow/c/text()
d /myXML/Rows/testRow/d/text()
e /myXML/Rows/testRow/e/text()
Where the stuff in slashes above is what goes into the Description.
On the output, for testing you can specify a file, although I prefer to send out a single column:
myXMLStuff varchar 999 /
Where it has a single '/' in the Description attribute. Send it to a Sequential Stage and put 000 in the delimter and quote character of the format to get a nice clean XML file.
You have lots to learn about the stages, but this should give you a good start.
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>
I had a lot more space between the a, b, c, d, e and the first slash when i made that entry.....the / should start each string in the Description.
Ernie
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>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you mean the 'Best Practices' document, you can download that from Kim Duke's site:
http://www.duke-consulting.com
Tips & Tricks page.
http://www.duke-consulting.com
Tips & Tricks page.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers