Solved

Cobol Database Migration

Posted on 2006-06-13
6
342 Views
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:

Signature=RMFK
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

 thanks

Mariano
0
Comment
Question by:MarianoSB
  • 2
  • 2
6 Comments
 
LVL 31

Expert Comment

by:moorhouselondon
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.
0
 
LVL 31

Accepted Solution

by:
moorhouselondon earned 250 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
0
 
LVL 24

Assisted Solution

by:SunBow
SunBow earned 250 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
0
 
LVL 24

Expert Comment

by:SunBow
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.
0
 

Author Comment

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

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
fix34  challenge 9 96
VB 6.0 printer how to align 6 49
mapAB Challlenge 35 85
move one pixel 4 41
I know it’s not a new topic to discuss and it has lots of online contents already available over the net. But Then I thought it would be useful to this site’s visitors and can have online repository on vim most commonly used commands. This post h…
Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
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 …

708 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

14 Experts available now in Live!

Get 1:1 Help Now