Solved

Convert Microsoft SQL to Cobol language

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

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…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
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…

839 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