Navigating within the Data Dictionary tool in UNIX

Launch the Data Dictionary tool

At the UNIX command prompt, launch Proenv:

proenv

Launch the Data Dictionary tool using this command:

pro -p dict.p

The Data Dictionary window opens, with the Database menu active.

Connect to a database

Press Enter on the Database menu, navigate to Connect, and then press Enter. The Connect Database window opens.

In the Physical Name field, navigate to Files and then to the directory where your database resides.

Navigate to the .db file of the database and then press Enter to select it. The Data Dictionary window opens.

• To access the database in multi-user mode, navigate to the Multiple Users check box, and then press Enter.
• To access the database in single-user mode, navigate to OK and then press Enter.

You are connected to the database as indicated by the database’s status in the lower-left corner.

Manage a database

The Data Administration tool has two menus:

• The Database menu enables you to create a new database, connect to an existing database, generate reports of database objects, and disconnect from a database.
• The Admin menu enables you to perform a number of tasks including:
  • Perform schema changes.
  • Dump and load data definitions, table contents, sequences, and sequence values.
  • Configure user security, domains, and authentication systems.

Disconnect from a database

Navigate to Database > Disconnect and then press Enter on Yes and press Enter on OK to disconnect from the database.

Exit the Data Dictionary tool

Navigate to Database > Exit and then press Enter to exit from the Data Dictionary tool.