Solved

Convert Microsoft SQL to Cobol language

Posted on 2008-06-25
4
247 Views
Last Modified: 2010-03-19
I am looking at trying to convert MSSQL to Cobol.  What I have is pay information that I save via ASP.net pages into MSSQL databases.  What we would like to do is convert this information to a fixed record block format with a length of 335 bytes and a blocksize of 32495.  
I gues the question is is this possbile to do this and what do I need to do it.
Thanks
0
Comment
Question by:kdeutsch
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 21871712
Oh my god.  Just curious, why do you need to do this?

My COBOL is rusty (about 3 years go I worked a on a legacy COBOL application that was being converted to .NET)

However, in some cases we had to push data back to COBOL.  We used to write a CSV file then wrote a COBOL method to convert the CSV into a COBOL files.

You could write a SQL package to create the CSV file in any size and format you specify.
0
 

Author Comment

by:kdeutsch
ID: 21873855
Well I have the same problem, I have to push pay files from my system over to a legeacy system that a company is keeping alive because it's their major accounting system.
0
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 250 total points
ID: 21878524
The file formats for all of the COBOL applications are proprietary so cracking them would be a pain.  Fujitsi had a product we used to run to interact with COBOL files using .NET.  Have you looked at it?
0
 

Author Comment

by:kdeutsch
ID: 21883050
no, I am just trying to figure out if possible using just SQL and code language, but it does not sound that way.  I have a meeting on Monday with the Legacy system director to see if its even possbile and what stuff they need.  Thanks for the info.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question