Solved

Convert Microsoft SQL to Cobol language

Posted on 2008-06-25
4
225 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
  • 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to PARSE a text field that is delimited by '~' character? 3 61
Query - which index being used? 2 52
Need help with a query 6 73
Unable to save view in SSMS 21 69
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

773 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