Cobol Database Migration

Posted on 2006-06-13
Medium Priority
Last Modified: 2011-10-03
Hi experts,

i must develop a system to a professional, and he she has an old cobol software. I found a tool that gives to me the next information:

Min Records=121
Max Records=331
Data Compression on
Space code = 32
Number code=48
Key compression on
Key number code = 32
Block Size = 512
Block Increment = 512
Block Contains = 0
Allocation increment = 0
Index block = 1768
No records = 5713
Integrity flag=0
Primary Key Offset = 0
Primary Key Lenght = 4
Empty block = 3

 Now i need to know how to process this information ( what is useful and what doesnt ) in java or .net


Question by:MarianoSB
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
LVL 31

Expert Comment

ID: 16898155
These are Constant values that COBOL needed to help define its environment.  Newer languages don't need you to define these things - they are handled automatically.  In fact, it is best to start off with a clean slate - making your software mimic COBOL's data structures could well be counter-productive.
LVL 31

Accepted Solution

moorhouselondon earned 750 total points
ID: 16898204
Here are my thoughts on what some of those values represent:-

Max Records=331
I have messed around software in the past which had a ceiling for the maximum number of records - if you want to expand the size of the table you had to do it using a special procedure.  Not applicable these days.

Space code = 32
The ASCII code for a Space character is 32

Number code=48
The ASCII code for a '0' character is 48, '1' is 49, etc.

Key number code = 32
The smallest ASCII code on your keyboard (apart from control characters) is the space bar (ASCII code 32)

Block Size = 512
When reading/writing to hard drive a record is defined as 512 bytes
LVL 24

Assisted Solution

SunBow earned 750 total points
ID: 16899227
Close enough, not that I know much better. You usually have more records than blocks, they are not same, the former being the data, the latter more the physical space. Think: sector(s).

> Max Records=331
> No records = 5713

This kind of thing befuddles imagination as much as MS-Speak. Among reasons I disliked Cobol. CD& could probably whip through it if you chose a better TA.

I probably agree with moorhouselondon

You should try to get data to flat file, first, ignore all of the above except that at your destination is a Cobol Professional. Show them the data and then ask what is needed/required. Can it import CSV file, or is it to be fixed column? Generally those are the more common forms, after dBase.

So learn to adapt you output accordingly, such as for ouputting text only, and for having all items of a field being equal in length, a language can be very finicky about that, getting columns to line up. You might be able to practice with MS-Office if you have it, try moving it to Access, for example.

If your friend is instead giving you the data, do the reverse, have them get it to you in an agreed format for a flat file that either has fixed length fields or can be delimited by commas if their language permits. It may depend on how old their language is. Some are running OOP
LVL 24

Expert Comment

ID: 16899245
>  Newer languages don't need you to define these things - they are handled automatically

It isn't cobol so much as how the back end is defined, and how that has improved over time. A language should not be so dependent on a specific format for an HD for example, other parts of system such as controllers and operating systems can do that well enough. But sometimes it pays also to first ensure there is sufficient disk space, before attempting to write to the file a character at a time, only to hav it all blow up on you in the middle of a run.

Author Comment

ID: 17236100
It wont be necessary, i forgot to close the commentary and to assign the points.  Thanks for warning.  Regards,    Mariano

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Six Sigma Control Plans

650 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