Originally posted by: Kepa_Screen

Hello:

We are developing a system with Mercator 6.7.1.
The input cards come from an Oracle AQ.

We want to extract the content of a field in AQ to a XML File, but we are newbie with XML and don't know what is the best way for creating this type tree for XML Output.

We tried first creating the type trees manually, but it's a very hard job, cause must type all tags manually for each field...We also have problems with "escaping characters ...">" "<" ..etc, so must consider another way to manage this.

Then we considered making DTD's manually, and then import this DTD's into type tree designer, using the Import utility...But we are not sure that the obtained type tree is ok or not.

Later, we are thinking in using XSD files ( XML Schemas ) in order to import and generate it's type trees, but we don't know how to create this XSD...

What would be the better way for generating type trees for our XML output ?? DTD import ?? XML Schema import ?? Is there any good free tool for creating XML Schemas ??

We are newbies using XML data output...so any idea, advice, etc, will be welcome.

Thank you very much in advance.
Sorry for the bad english
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

If you've got sample xml you can use xmlspy to create DTD or XSD and amend the resulting file if necessary. This can then be imported into Type Designer.
However, the designer of the xml output should provide an xds for it so that you are able to validate your xml.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: Kepa_Screen

Hi, thank you very much for the reply.

We knew this solution, but the problem is that we are generating the XML files, so we do not have this files before the type trees and maps.

The input for the maps comes from an Oracle AQ, then the map takes some fields of the input and create the output like a XML file. So the first XML file we got was created by us.

Thanks again, we are going to try XMLSpy.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange