XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Flat File (From mainframe COBOL Programs with Copybook) to XML conversion
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + element type must not contain ... (3)
-> + XML to .txt file (7)
-> + Modifying a XSL-FO report (5)
-> + Retrievning multiple values...... (2)
-> + does Stylus Enterprise work wi... (2)
-> + MSSQL to 837P conversion (4)
-> + Generating XML files accesing ... (6)
-> + How to bold text using XSL (6)
-> + Different heading based on pag... (3)
-> + Code folding (2)
-> + Bad param=value pair on comman... (2)
-> + Saving an XML file (2)
-> + stylus adding random non print... (2)
-> + Displaying Base64Binary as Ima... (6)
-> - probleme de representation d'i... (1)
-> + SS 2008 error message not disp... (8)
-> + XQuery external variable conve... (4)
-> + encodings available (3)
-> + stand-alone application file n... (4)
-> + Windows Installer Dialog Box a... (4)
-> + Block search and replace (2)
-> + Problem with validation (3)
-> + ISA12 vs GS08 (5)
-> + Web Service Call failure... an... (11)
-> + Quotes in xpath query (3)
-> + Java Built-in processor no lon... (6)
-> + Dynamic input and output names (8)
-> + Java built-in parser (3)
-> + Contains an invalid path (2)
-> + Wizard XML Schema to XML (2)
-> + XML to EDI (14)
-> + Computer with original install... (2)
-> + using Custom Tool - passing ar... (3)
-> + Non-printable special characte... (3)
-> + Transfer Options (Settings, Pr... (2)
-> + Enterprise Edition, Rel. 3, Bu... (9)
-> + Need help with xsl file and xm... (2)
-> + Upgrading and retaining settin... (4)
-> + saxon9.dll etc. missing (2)
-> - Error on using XQuery File in ... (1)
-> - Strange Dialog Box (1)
-> + Studio Crashes in schema edito... (3)
-> + Xml to XMl Conversion (2)
-> + Unable to create a complex typ... (2)
-> + Error message wen trying run j... (2)
-> - XSLT Mapper question... (1)
-> + Dcument Wizard XSLT Editor Tab... (2)
-> + Beginner Question - XPath with... (2)
-> + Trying to generate .net code w... (2)
-> + duplicate values in variable w... (5)
-> + Java Runtime Environment libra... (4)
-> + programmatically generate XML ... (4)
-> + Help Loading Oracle BI Publish... (4)
-> + [French] xsl <=> report (3)
-> + XML Diff (3)
-> + StylusStudio 2008, saxon saxon... (6)
-> + Msql Table err:FODC0004 Table ... (2)
-> + The evaluation period for Data... (2)
-> + Mysql to XML (2)
-> + Is there a Collapse All nodes ... (2)
-> + flat file conversion with CDAT... (4)
-> + Struzzo.exe eats up %40 CPU ba... (2)
-> + schematron support? (11)
-> + XML Generator did not generate... (2)
-> + Nesting XML files (2)
-> + Web Service Call fails - targe... (5)
-> + getting not valid for content ... (2)
-> - element modem was referenced i... (1)
-> + xerces-c++ xml parser (2)
-> + movie.dtd (2)
-> + HELP! Stylus Studio 2008 Enter... (3)
-> + Xalan problem with xsl:attribu... (2)
-> + Breakpoints being ignored (12)
-> + Need a new key for Stylus Stud... (2)
-> + Global parameters are not reco... (4)
-> + mySQL DB Connection 2 (10)
-> + Using Data Direct xQuery to ag... (4)
-> + stylusXslt command line -- XSL... (15)
-> + XSLT processor using EXSLT fun... (2)
-> + Integrating Omni Mark (2)
-> + EDI Standards to gXML (2)
-> + flat file conversion (3)
-> + EDI to XML: Invalid URI error (3)
-> + Validating and XML Schema (6)
-> + XSD to DDL (MS-SQL/2005) (6)
-> + xml converter cant encode 0x19 (4)
-> + XSD Help Needed (2)
-> + How do you delete a field in a... (2)
-> + Disable page breaks (3)
-> + XSD semantic structure compari... (3)
-> + Studio Crashes On File Open (7)
-> + Which parser is used by Stylus... (2)
-> + How to DIFF XML windows with d... (3)
-> + Automation using Visual Studio (7)
-> + CSV to XML conversion help (2)
-> + XML tree help (3)
-> + java.lang.NullPointerException... (2)
-> + Creating schema from xml - how... (3)
-> + Mismatch between intellisense ... (4)
-> + Using FOP 0.94 in XML Pipeline (2)
-- Previous [1081-1100] [1101-1120] [1121-1140] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
sebastien vinchonSubject: Flat File (From mainframe COBOL Programs with Copybook) to XML conversion
Author: sebastien vinchon
Date: 04 Feb 2008 11:37 AM
Originally Posted: 04 Feb 2008 11:32 AM
Hello,

One of my customers (a large bank from Luxembourg) is in need for a solution to convert flat files generated by Mainframe COBOL programs into XML.

I am trying to convince them that your products are the right ones to do this (COMV + xQuery).

However:
- They have COBOL copybooks that describe the structure of their flat file and it seems painful to have to manually recreate a CONV file in Stylus when those files already provide all the needed information
- I haven't been able to find a good example on how to convert a record oriented file to XML using Stylus

In the worst case, the input file could be made of several blocks of data (one per customer for instance), with several record types (account, transactions, etc) per block and multiple occurrence of certain record types (n transaction for the same account) inside the same block.

It seems to me that it should be possible to write some code to automatically generated a CONV file out of a COBOL copybook.

I am attaching a sample flat file together with the copybook that describes its structure.

Can anybody help?


UnknownHISAVI.TXT
Sample Flat File

UnknownStructureHISAVI.TXT
Copybook
Postnext
Tony LavinioSubject: Flat File (From mainframe COBOL Programs with Copybook) to XML conversion
Author: Tony Lavinio
Date: 04 Feb 2008 04:51 PM
We took a look, but had a little trouble understanding the
output of the DECIMAL fields. They look like COMP-3, but
they are left-padded with 0x20 (blank) bytes instead of
zeros. Unfortunately, in COMP-3, 0x20 also means the digits
'2' and '0' - at least when rendered as ISO-8859-1 or cp1252,
which your output appears to be.

Otherwise, we could help you further.
Postnext
sebastien vinchonSubject: Flat File (From mainframe COBOL Programs with Copybook) to XML conversion
Author: sebastien vinchon
Date: 05 Feb 2008 04:48 AM
Many thanks for responding so quickly.

You are right that there seems to be something wrong with the sample input file.

I am wondering if my customer did not make a mistake during file transfer from the mainframe.

Let me try to get more information from my customer.

What sort of help could you provide?

Do you have any plans to add the ability to import a COBOL copybook to create a CONV automatically in Stylus Studio?
Postnext
Tony LavinioSubject: Flat File (From mainframe COBOL Programs with Copybook) to XML conversion
Author: Tony Lavinio
Date: 05 Feb 2008 07:41 AM
We don't, but we might be able to provide some guidance if
we can see a good sample that will help you to do it quickly,
and perhaps even automate the process.
Postnext
sebastien vinchonSubject: Flat File (From mainframe COBOL Programs with Copybook) to XML conversion
Author: sebastien vinchon
Date: 05 Feb 2008 04:30 PM
Originally Posted: 05 Feb 2008 04:27 PM
I am waiting for feedback from my customer.

In the meantime, can someone tell me the right way to write a CONV and an xQuery based on the attached files.

This should allow me to move forward once my customer gets back to me.

I am pretty sure it is possible to automatically generate a CONV out of a COBOL copybook but I will look into that as a second step.

Thanks for any help.


UnknownSampleInput.TXT


UnknownSampleInputStructure.TXT


UnknownDesiredOutput.xml
Postnext
Minollo I.Subject: Flat File (From mainframe COBOL Programs with Copybook) to XML conversion
Author: Minollo I.
Date: 05 Feb 2008 05:30 PM
Originally Posted: 05 Feb 2008 05:29 PM
If I well understand the description of your format and output, the attached two files may help; the XQuery has to do positional grouping, as the input format seems to rely on position to associate transactions to accounts; the code assumes that test.conv is on c:\


Documenttest.conv


Unknownsebastien(1).xquery
Postnext
sebastien vinchonSubject: Flat File (From mainframe COBOL Programs with Copybook) to XML conversion
Author: sebastien vinchon
Date: 06 Feb 2008 03:57 AM
An additional potentially useful piece of information is that the input file can be VERY large so I hope your engine is able to read it by block to avoid running out of memory.
Postnext
sebastien vinchonSubject: Flat File (From mainframe COBOL Programs with Copybook) to XML conversion
Author: sebastien vinchon
Date: 06 Feb 2008 04:26 AM
Originally Posted: 06 Feb 2008 04:24 AM
This example is of great help to understand the flat file to XML conversion capabilities of your product.

You should include it in the documentation :-)

I am very impressed by your response time and you willingness to help.

Thank you very much.
Posttop
Govind RathiSubject: Flat File (From mainframe COBOL Programs with Copybook) to XML conversion
Author: Govind Rathi
Date: 13 Feb 2019 02:42 PM
I have a similar requirement. I am attaching copybook as well as the file I need to convert.

Please help.
Thanks


UnknownMasterCardChargeBackCopyBook.txt
Copybook format

UnknownCMRD3509.11282018.173557.txt
Source file to convert
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.