Solved

Convert Microsoft SQL to Cobol language

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

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Error in SSIS while executing  - Potential data loss 4 42
Help Required 2 58
Using this function 4 54
Better way to filter date  - Query 5 45
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

710 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