SSDN - Flat file to XML on Mainframes

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Akshat Ruia

Subject: Flat file to XML on Mainframes
Author: Akshat Ruia
Date: 20 Feb 2006 07:37 AM

I have to convert a extract (flat) file (from a COBOL program) to XML.
I have the schema of the required XML format. How do i go ahead with this conversion.
Can this be done on mainframes our will it have to be using a tool on Open-systems.

(Deleted User)

Subject: Flat file to XML on Mainframes
Author: (Deleted User)
Date: 20 Feb 2006 09:07 AM

Hi, Akshat. Yes, you can convert flat files to XML using the Convert to XML module in Stylus Studio. You can view a video demonstration of this module here:

http://www.stylusstudio.com/learn_convert_to_xml.html

David Foster
Stylus Studio Team

Akshat Ruia

Subject: Flat file to XML on Mainframes
Author: Akshat Ruia
Date: 21 Feb 2006 01:09 AM

>Hi, Akshat. Yes, you can
>convert flat files to XML
>using the Convert to XML
>module in Stylus Studio. You
>can view a video demonstration
>of this module here:
>
>http://www.stylusstudio.com/le
>arn_convert_to_xml.html
>
>David Foster
>Stylus Studio Team

As i mentioned earlier, I already have the schema for the required XML file. Howver, i don't think that the above tool is a automated one. Can he have a tool, which gets a cobol flat file as inout and gives an XML output using the schema and preferably running on mainframes.

(Deleted User)

Subject: Flat file to XML on Mainframes
Author: (Deleted User)
Date: 21 Feb 2006 01:02 PM

Hi, Akshat. Yes, you can automate the conversion of COBOL files to XML using one of two methods in Stylus Studio:

First, if you are using Stylus Studio 2006 XML Enterprise Edition, you can use our Adapter API to programmatically call an adapter. You can learn more about that process here:

http://www.stylusstudio.com/custom_adapter.html

Second, you can execute a stylesheet from the command line (StylusXslt.exe), invoking an identity transform on the input URL specified as adapter://...

Identity transforms are:
<xsl:template match="/">
<xsl:copy-of select="."/>
</xsl:template>

You can learn more about executing Stylus Studio from the command line here:

http://www.stylusstudio.com/docs/v2006/d_start83.html#wp405262

Regardless of which path you pursue, note that we have tested the COBOL adapter in a few use cases, and we'd be interested to know of any troubles you encounter.

Hope this helps.

David Foster
Stylus Studio Team

Akshat Ruia

Subject: Flat file to XML on Mainframes
Author: Akshat Ruia
Date: 22 Feb 2006 02:38 AM

Thanks for the responses. However, I am not yet clear whether your tool can meet my requirements. Hence i am repeating them.

My requirement is to convert a flat file which is being generated on m/f. This file is generated daily and will have to be converted into XML on a daily basis. There should not be any human intervention required once the conversion job has been fired. I hope you have understood my exact requirement now.

I have thought of two possible solutions:
1) I could define the schema outside mainframes and provide the flat file as input to have this converted to XML.

2) The other option is to have schema defined on mainframe such that the process itself creates an XML without any need to convert later.

I also have a few queries:

1) How does the tool handle the Min Occurs = 0 for a field
2) When i provide the schema, does that act as a reference while conversion?

If you are not clear on my requirements then please revert back to me.

(Deleted User)

Subject: Flat file to XML on Mainframes
Author: (Deleted User)
Date: 22 Feb 2006 01:16 PM

Hi, Akshat.

Yes, you can use the Stylus Studio Adapter API to automate the flat file conversion process. Any machine that supports JVM 1.4 or higher is able to run applications developed using the Adapter API.

XML Schema is not considered during the conversion process, but you can likewise validate the XML resulting from the conversion against an XML Schema by invoking a Stylus Studio validation utility from the command line. This is described here:

http://www.stylusstudio.com/docs/v60/d_start_html83.html

Hope this helps.

David Foster
Stylus Studio Team

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.