Link to home
Start Free TrialLog in
Avatar of Gianlu68
Gianlu68

asked on

read rpg data file in windows

Hello,
we have to transfer data from an old rpg program to a new SQL based database, does anyone know if there are utilities or a procedure to do this? The rpg program is compiled an run under dos environment. thanks.
Avatar of dbrunton
dbrunton
Flag of New Zealand image

More information required.

Name of application or is this an application specifically written for the task in RPG?

-----------------------------------------------------------------

If you've got code you should be able to convert the data across.

If you haven't got code you may able to determine the data structure of your data files and thus convert it across.

You may be able to do a printout of all your data to a file.  That may well be able to be converted across.
Avatar of Gianlu68
Gianlu68

ASKER

hello, we dont't have a code. The procedure is an account program. Where normally RPG store data? in wich file format?
We are not able to printout data to a file because the procedure run in a old dos environement and we dont't have a PC to do this. If possibile we want to open a data files and retrieve record.
Thanks.
Name of the account program please.
the name of te account program is not important bacause is an old italian account program and i don't think you know. But if you want the program name is SINTONIA. My question is "How i can retrieve data from rpg file archive? is possibile? where rpg store data normally (file extension)?
thanks.
Look in the folders where the SINTONIA application is using Windows Explorer.  Click on the Modified column (see the picture).  This will put the files in date order.  Find the files with the most recent dates.  These are the data files.  See what extension these are and post here.
Modified.jpg
What does the data look like?

What relational database are you importing into?
The only SINTONIA I see is a dictionary application.
You have this tagged with [rpg iv] but also said:

The rpg program is compiled an run under dos environment.

Those two don't go together.

If it really is [rpg iv], I've never heard of any compiler the creates DOS executeables. How do you know it has anything to do with "rpg" at all (much less [rpg iv])?

Tom
there wa some compiler that run under dos environement, one was lattice. But we resolve the problem in another way.
thanks for the answers.
@Gianlu68

What was your work-around?
I work for a software house. I'm senior developer and software analyst.
I meant "what did you do to circumvent the problem?"
ASKER CERTIFIED SOLUTION
Avatar of Gianlu68
Gianlu68

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Please accept your comment (http:#33022203) as the solution.
there wa some compiler that run under dos environement, one was lattice.

True. However, I was only aware of the Lattice RPG for DOS compiler handling RPG II. At least some RPG IV support was available from Lattice, but I thought it required upgrading at least to the Windows version.

In any case, the question really has probably nothing to do with "RPG". It has to do with Lattice and their methods (or the methods of whatever company supplied the compiler). Files used by programs compiled with Lattice and other PC compilers would generally be proprietary. But files used by actual RPG IV programs would generally be either DB2 TABLEs or physical files that are compatible with DB2 TABLEs.

For an answer that fits your need, we'd need to know something about the compiler that created the programs. We would definitely need to know what company created the compiler.

Tom