Hello, as a new person to Datastage, I am after some info and hope someone can help.
I need to create an xml file from data taken from multiple sources on a z/OS machine. The xml file must be resident on the mainframe. I have been reading docos on DataStage XE 390 and from what I can see, there is no way to do this using DataStage XE 390, and I would have to FTP (for instance) to DataStage on Windows and perform the translation there. Is this correct?
Thanks in anticipation,
Stephanie Caston
create xml on mainframe
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 10
- Joined: Fri May 28, 2004 8:01 am
- Location: Netherlands
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
You are correct, your mainframe source files need to be transferred to your DataStage server for processing. If you are using FTP it is useful to use some mechanism that tells the DataStage job that the file has been completely transferred such as the creation of a flag file or a final MV command once the FTP is complete.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard! :D
Does your nickname mean you're an Aussie working in the Netherlands?
There's no DS390 equivalent of the XML writer stage. So, yes, the only way to do this solely using DataStage would be to generate, for example, a delimited flat file on the mainframe and use an FTP stage to send this to somewhere that you can run DataStage server jobs.
Here you could generate the XML then return it to the mainframe, again using FTP.
Good luck with the politics of being permitted to FTP files to the mainframe! (The technical part is easy; getting permission is another thing entirely!)
Does your nickname mean you're an Aussie working in the Netherlands?
There's no DS390 equivalent of the XML writer stage. So, yes, the only way to do this solely using DataStage would be to generate, for example, a delimited flat file on the mainframe and use an FTP stage to send this to somewhere that you can run DataStage server jobs.
Here you could generate the XML then return it to the mainframe, again using FTP.
Good luck with the politics of being permitted to FTP files to the mainframe! (The technical part is easy; getting permission is another thing entirely!)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 10
- Joined: Fri May 28, 2004 8:01 am
- Location: Netherlands