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)
-> - UV Kit (1)
-> - Preview PDF as HTML? (1)
-> + ArrayIndexOutOfBoundsException... (3)
-> + WSCC to KML transform help (5)
-> + Using XSV 3.1-1 as an external... (2)
-> + Cannot debug stylesheet (2)
-> + Error installing Stylus Studio... (3)
-> - Windows XP "not responding" er... (1)
-> - Windows XP "not responding" er... (1)
-> + HTML to XSL (2)
-> + Run Stylus studio from command... (2)
-> + Setting Context for XPath Quer... (5)
-> + Batch process to check well-fo... (9)
-> + WSDL validator? (8)
-> - How to be still using Old Jars (1)
-> - Install Stylus Studio on anoth... (1)
-> + Install Stylus Studio on anoth... (3)
-> + How to validate via catalog lo... (4)
-> + New Installation Upgrade Issue... (4)
-> - Freelance Project - Mapping di... (1)
-> + Converting from Edifact to SQL... (3)
-> + converting data file to xml us... (2)
-> + have serious problem with Styl... (2)
-> + ddtek:sql-delete (3)
-> + Web Service Call with Axis: No... (3)
-> + Entity gets replaced when inde... (2)
-> + EDIFACT import error (3)
-> + (401) forbidden error (8)
-> + Error when data type not speci... (2)
-> - Globally delete duplicates of ... (1)
-> + Validation too slow!!!! (4)
-> + Define a complex type with mul... (2)
-> + XML Playlists (2)
-> - Create SOA Web Service with me... (1)
-> + Spell checking?? (2)
-> - saxon 9 linebreak in text mode (1)
-> + Apache FOP gets NoClassDefFoun... (3)
-> + Nillable Decimal (4)
-> + Transform XML to AS400 Databas... (4)
-> + xs3p vs xsDoc (3)
-> + Update Installation Problem (11)
-> + Java Heap error and -Xmx param (5)
-> + 2007 Pro won't run XSL files c... (3)
-> + access to multiples databases ... (6)
-> + License Authentication Failed (2)
-> + XSLT Mapper: How to aggregate ... (2)
-> + Why my WYSIWYG tab disappeared... (3)
-> - Flat File (From mainframe COBO... (9)
-> ->Flat File (From mainframe...
-> ->Flat File (From mainframe...
-> ->Flat File (From mainframe...
-> ->Flat File (From mainframe...
-> ->Flat File (From mainframe...
-> ->Flat File (From mainframe...
-> ->Flat File (From mainframe...
-> ->Flat File (From mainframe...
-> + X12 Validation (5)
-> + Schema replacement in Microsof... (2)
-> + [OT] XML fragment - error expl... (3)
-> + Re-using a simple type definit... (2)
-> + What is "Java bult-in" XSLT Pr... (2)
-> + Error when generating .NET cod... (6)
-> + options for sum(function) - to... (2)
-> + [OT] XSD - is this valid XML o... (2)
-> + Multiple page sequences (2)
-> + License disabled (3)
-> + EDIFACT to XML with multiple Q... (5)
-> + Viewing Web Service Call http ... (2)
-> - keyref handling by different p... (1)
-> + Running transform in SS UI com... (9)
-> + Mapping from one schema to ano... (3)
-> - Using document() to lookup fro... (1)
-> + Can not open a xml file in IE ... (2)
-> + Stylus Studio detected a chang... (3)
-> + Customer Support for Stylus St... (2)
-> + WebService Call is not working... (3)
-> + Activation Problem (2)
-> + Activating Stylus Studio 2008 (3)
-> + Cannot use UNC paths, get save... (22)
-> + DB to XML Data Source not avai... (3)
-> + Stylus Studio 2008 Installatio... (16)
-> - SQL Server 2005 xml datatype -... (1)
-> + XML Reporting: linking to sect... (4)
-> + Merge an external xml with inp... (4)
-> + Stylus Closing abruptly (4)
-> + Best approach for generating X... (2)
-> + Problem with Java call (5)
-> + Changing the top margin (2)
-> + Generating a Web Service Call (2)
-> + import xml into excel using V... (2)
-> + FOP producing NoSuchMethodErro... (6)
-> + Reporting Errors (2)
-> + Doc/Literal Wrapped (2)
-> + Need image to render at higher... (3)
-> + HTML to xml wizard on thousand... (2)
-> + Doc/Literal and SOAP Header/Bo... (2)
-> - Help with settping up MS Acces... (1)
-> + WSDL - A Well Defined Service (7)
-> + XML to XML Mapping - Combining... (2)
-> + CData Question (3)
-> + mySQL DB Connection (11)
-> + XPath documentation confusion (2)
-> + Extra block/CR generated (6)
-> + Apache FOP (2)
-> + Inserting Java Script (2)
-> + Convert EDIFACT to X12 or vice... (6)
-> + XSD: Restricting an attribute ... (2)
-> + Creating dynamically named ele... (2)
-- Previous [1201-1220] [1221-1240] [1241-1260] 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.