skip to main content
OpenEdge Getting Started: Progress OpenEdge Studio
Working with the Sample Application : Creating and connecting to the Sports2000 database
 
Creating and connecting to the Sports2000 database
Before running or assembling the sample application described in this chapter, you must create a copy of the Sports2000 database and connect to it.
To complete this task, you use the Data Dictionary tool. The Data Dictionary is part of the OpenEdge Studio. With it, you can create and connect to databases, as well as edit the definitions of tables, fields, indexes, and other database‑related information.
Making a copy of the Sports2000 database allows you to make changes to the copy while preserving the original database unchanged for future use. You can also replace your working copy using the Replace If Exists option.
To create and connect to your copy of the Sports2000 database:
1. Choose ProgramsOpenEdgeDesktop from the Windows Start menu.
2. Select the Data Dictionary icon from the Desktop.
3. When you run the Data Dictionary, it looks for a connected database. If there is no connected database, the Dictionary Startup dialog box appears:
4. Select Create a New Database and click OK. The default selection for the Dictionary Startup dialog box is Connect to an Existing Database. The Create Database dialog box appears:
5. Type <wrk>\databases\sports2000.db for the New Physical Database Name, where <wrk> is your OpenEdge working directory.
6. Select A Copy of Some Other Database in the Start with radio set. The default selection is An EMPTY Database.
7. Click the Files button, browse to the location of the original Sports2000 database, and select it.
Note: If you installed the sample files in the default location, the Sports2000 database is located inC:\Progress\OpenEdge.
8. Click OK.
The Data Dictionary creates a copy of the Sports2000 database in your working directory. The Connect Database dialog box appears and displays the name of the database you just created:
9. Click OK in the Connect Database dialog box. The Data Dictionary makes the connection and its startup window appears:
You have now created and connected to your working copy of the Sports2000 database. The Data Dictionary window shows the Sports2000 database and the tables in the database.
The icons in the toolbar govern what you can do with the Data Dictionary and what information displays for the selected database. When you choose an icon, buttons for varying tasks appear at the bottom of the window. Table 2–1 lists the icons and their associated displays and tasks.
 
Table 2–1: Data Dictionary icons 
Icon
Displays
Available task buttons
Connected databases
Create Database
Database Properties
Tables in selected database
Create Table
Table Properties
Delete Table
Sequences in selected database
Create Sequence
Sequence Properties
Delete Sequence
Fields in selected table
Create Field
Field Properties
Delete Field
Indexes on selected table
Create Index
Index Properties
Delete Index
10. Use the Data Dictionary to familiarize yourself with the structure of the Sports2000 database.
11. When you are ready, close the Data Dictionary and return to the Desktop.