progress-4gl Getting started with progress-4gl Creating the "sports2000" demo database from the command line
Example
This shows how to create the demo database used in big parts of Progress documentation: sports2000.
This assumes you have installed the Progress products with at least one type of database license.
Run proenv script/bat-file that will give you a prompt with all environment variables set.
Create a directory.
This example is for Windows. Directory handling etc might be different in another OS.
proenv> cd \
proenv> mkdir db
proenv> cd db
proenv> mkdir sports2000
proenv> cd sports2000
Create a sports2000 database using "prodb"
proenv> prodb mySportsDb sports2000
Syntax of prodb:
prodb name-of-new-database name-and-path-of-source-database
This will create a database called "mySportsDb" in the current directory. That database is an exact copy of the sports2000 database that's shipped with the Progress install. Since the source sports2000 database is located in the Progress install directory you don't need to specify path.
If you look at the directory content you will see some files:
proenv> dir
2017-01-12 20:24 2 228 224 mySportsDb.b1
2017-01-12 20:24 1 703 936 mySportsDb.d1
2017-01-12 20:24 32 768 mySportsDb.db
2017-01-12 20:24 2 951 mySportsDb.lg
2017-01-12 20:07 368 mySportsDb.st
2017-01-12 20:24 327 680 mySportsDb_10.d1
2017-01-12 20:24 65 536 mySportsDb_10.d2
2017-01-12 20:24 1 310 720 mySportsDb_11.d1
2017-01-12 20:24 1 376 256 mySportsDb_11.d2
2017-01-12 20:24 327 680 mySportsDb_12.d1
2017-01-12 20:24 65 536 mySportsDb_12.d2
2017-01-12 20:24 327 680 mySportsDb_7.d1
2017-01-12 20:24 65 536 mySportsDb_7.d2
2017-01-12 20:24 655 360 mySportsDb_8.d1
2017-01-12 20:24 655 360 mySportsDb_8.d2
2017-01-12 20:24 327 680 mySportsDb_9.d1
2017-01-12 20:24 65 536 mySportsDb_9.d2
| File name | Contains |
|---|---|
| .db | The main database file. Contains the database schema |
| .lg | The database log file. Contains logging information in text format |
| .st | The database structure file. Describe the storage layout in a text format |
| .d? | The actual data. Different files store data of different formats. The .st file can tell what format |
| .b? | Before-Image files. Contains information about transactions in process. |
Now you can access the database directly by simply typing pro mySportsDb. This will start a Progress Editor that's connected to the database. This will be a single user connection so nobody else will be able to access the database at the same time.
In the editor you can simply type:
FOR EACH bill NO-LOCK:
DISPLAY bill.
END.
To access the database. Press Ctrl+X to execute. This will display all contents of the "bill" table. If you want to cancel you can press Ctrl+C.
