Question Ancient Progress 5.2 on SCO - ASCII dump of database?

Bleve

New Member
G'day,
I have an ancient SCO OpenServer 5.0.4 (!) server running a progress database and application, /usr/dlc/version says :

bash-2.02# cat version
echo PROGRESS Version 5.2I as of Thu Feb 15 17:03:14 EST 1990


I would very much like to be able to get some sort of an ASCII dump of the database so I can import it into an SQL database and do some basic queries against it.

I haven't been able to find much/any doco for how I might do this, does anyone here have any clues as to where I might find doco for such an ancient version? Or have any suggestions for what commands might work to do it? There's an ascii.out file in the database's working directory from ~15 years ago, so presumably it's been done with this software at some point!

All I can see is :
#cat README.PRO
ADDITIONAL NOTES FOR THIS RELEASE
PLATFORM: SCO Xenix 386
MEDIA TYPE: High Density 5 1/4 Diskette
SOFTWARE RELEASE: 5.2I
MOUNT COMMAND: mount /dev/fd096ds15 /mnt
INSTALL COMMAND: /mnt/proinstall
MACHINE NOTES:
OPERATING SYSTEM NOTES:
TERMINAL NOTES:
SOFTWARE NOTES:

and /usr/dlc has :

/usr/dlc
bash-2.02# ls -la
total 6468
drwxrwxrwx 9 210 102 1536 Jul 2 2008 .
drwxrwxr-x 23 root auth 512 Oct 24 2017 ..
-rwxrwxr-x 1 root root 283 Jul 2 2008 README.PRO
-rwsrwxr-x 1 root root 147876 Jul 2 2008 _dbutil
-rwxrwxr-x 1 root root 5336 Jul 2 2008 _isroot
-rwsrwxr-x 1 root root 145710 Jul 2 2008 _mprosrv
-rwsrwxr-x 1 root root 122985 Jul 2 2008 _mprshut
-rwsrwxr-x 1 root root 512556 Jul 2 2008 _mprstrt
-rwsrwxr-t 1 root root 557859 Jul 2 2008 _progres
-rwsrwxr-x 1 root root 270540 Jul 2 2008 _proutil
-rwsrwxr-x 1 root root 169070 Jul 2 2008 _rfutil
-rwxrwxr-x 1 root root 20452 Jul 2 2008 _tlr
-rwxrwxr-x 1 root root 50 Jul 2 2008 applhelp.p
-rwxrwxr-x 1 root root 328 Jul 2 2008 applhelp.r
-rw-r--r-- 1 root root 16273 Jul 2 2008 ascii.out
-rwxrwxr-x 1 root root 197 Jul 2 2008 bpro
-rwxrwxr-x 1 root root 33880 Jul 2 2008 cmpdb
-rwxrwxr-x 1 root root 54485 Jul 2 2008 dbf
-rwxrwxr-x 1 root root 282624 Jul 2 2008 demo.db
-rwxrwxr-x 1 root root 231 Jul 2 2008 dict.p
-rw-r--r-- 1 root root 231 Jul 2 2008 dict.p-
-rwxrwxr-x 1 root root 456 Jul 2 2008 dict.r
-rwxrwxr-x 1 root root 38912 Jul 2 2008 empty.db
-rw-r--r-- 1 root root 95 Jul 2 2008 func_reset
-rwxrwxr-x 1 root root 988 Jul 2 2008 hello
-rwxrwxr-x 1 root root 4844 Jul 2 2008 help.p
-rwxrwxr-x 1 root root 11892 Jul 2 2008 help.r
-rw-r--r-- 1 root sys 3200 Jul 2 2008 hyper
-rw-r--r-- 1 root other 34 Jul 2 2008 lll
-rwxrwxr-x 1 root root 741 Jul 2 2008 login.p
-rwxrwxr-x 1 root root 1292 Jul 2 2008 login.r
-rwxrwxr-x 1 root root 321 Jul 2 2008 mbpro
drwxr--r-- 2 root root 512 Jul 2 2008 menu
-rwxrwxr-x 1 root root 390 Jul 2 2008 mpro
-rw-r--r-- 1 root root 390 Jul 2 2008 mpro-
-rwxrwxr-x 1 root root 333 Jul 2 2008 newkywd
-rwxrwxr-x 1 root root 246 Jul 2 2008 pro
-rwxrwxr-x 1 root root 62 Jul 2 2008 probkup
-rwxrwxr-x 1 root root 62 Jul 2 2008 procopy
-rwsrwxr-x 1 root root 29158 Jul 2 2008 prodb
-rwxrwxr-x 1 root root 24644 Jul 2 2008 prodel
drwxrwxrwx 2 root root 1536 Jul 2 2008 prodemo
drwxrwxrwx 2 root root 3072 Jul 2 2008 prodict
drwxr--r-- 2 root root 512 Jul 2 2008 proguide
drwxrwxrwx 4 root root 1024 Jul 2 2008 prohelp
drwxr--r-- 4 root root 512 Jul 2 2008 prohlc
-rwxrwxr-x 1 root root 436 Jul 2 2008 prolog
-rwxrwxr-x 1 root root 58 Jul 2 2008 promon
-rwxrwxr-x 1 root root 112347 Jul 2 2008 promsgs
-rwxrwxr-x 1 root root 62 Jul 2 2008 prorest
-rwxrwxr-x 1 root root 65 Jul 2 2008 proserve
-rwxrwxr-x 1 root root 77 Jul 2 2008 proshut
-rwxrwxr-x 1 root root 1514 Jul 2 2008 prostart.p
-rwxrwxr-x 1 root root 2940 Jul 2 2008 prostart.r
-rwxrwxr-x 1 root root 63 Jul 2 2008 prostrct
-rw-r--r-- 1 root sys 24186 Jul 2 2008 protermcap
-rw-r--r-- 1 root other 15449 Jul 2 2008 protermcap+
-rwxrwxr-x 1 root root 24194 Jul 2 2008 protermcap-
-rw-r--r-- 1 root sys 22453 Jul 2 2008 protermcap.bw
-rw-r--r-- 1 root sys 24194 Jul 2 2008 protermcap.david2002
-rw-r--r-- 1 root sys 22453 Jul 2 2008 protermcap.djm
-rw-r--r-- 1 root sys 17194 Jul 2 2008 protermcap.orig
-rw-rw-r-- 1 root other 22423 Jul 2 2008 protermcap.p5
-rw-r--r-- 1 root sys 22423 Jul 2 2008 protermcap.termcap.pre.w2k
-rw-r--r-- 1 root sys 24194 Jul 2 2008 protermcap.test1
-rwxrwxr-x 1 root root 73 Jul 2 2008 proutil
drwxr--r-- 2 root root 512 Jul 2 2008 qbf
-rwxrwxr-x 1 root root 29719 Jul 2 2008 quoter
-rwxrwxr-x 1 root root 15415 Jul 2 2008 quoter.c
-rwxrwxr-x 1 root root 72 Jul 2 2008 rfutil
-rwxrwxr-x 1 root root 3009 Jul 2 2008 tailor
-rwxr-xr-x 1 root root 65536 Jul 2 2008 test.bi
-rwxr-xr-x 1 root root 282624 Jul 2 2008 test.db
-rwxr-xr-x 1 root root 622 Jul 2 2008 test.lg
-rwxrwxr-x 1 root root 64 Jul 2 2008 version
-rw-r--r-- 1 root sys 24194 Jul 2 200

Which is presumably all the available commands.

The database and all its bits & pieces are in /u/aam.y2k, including the main database files:

-rw-r--r-- 1 root sys 2359296 Aug 3 13:13 aam.bi
-rw-r--r-- 1 root sys 119085056 Aug 3 13:13 aam.db
 

TomBascom

Curmudgeon
You should be able to get into the data administration menu with this:

Code:
mpro aam -p dict.p

From there navigate to:
Code:
Database Schema Admin DataServer Utilities PRO/SQL Tools
                ┌────────────────────────────────────────┐
                │ Dump Data and Definitions ->           │
                │ ┌────────────────────────────────────────────┐
                │ │ Data Definitions (.df file)...             │
                │ │ Table Contents (.d file)...                │
                │ │ SQL Views...                               │ome to the OpenEdge Data Dictionary ─────────────┐
                │ │ ────────────────────────────────────────── │                                                 │
                │ │ User Table Contents...                     │e facilities to set up or alter the structure of │
                │ │ Security Domains...                        │ or to perform various administrative functions. │
                │ │ Security Permissions...                    │                                                 │
                │ │ ────────────────────────────────────────── │─────────────────────────────────────────────────┘
                └─│ Auto-Connect Records only...               │

Dump table contents to .d files is what you want. You will get space delimited quoted text. It is probably not worth the effort to futz around getting a "better" format.

Is this on "bare metal" or a VM?
 

Bleve

New Member
It's on a VM, I managed to get 5.0.4 to run on VMware player some time in 2008 I think. The client had been running it on bare metal for 15+ years, with the same old tape drive, and the same tapes! I could never get it to boot cleanly on virtualbox though.
 
Top