Solved

Convert Microsoft SQL to Cobol language

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

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 …
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

867 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now