Progress/400
Product Guide
Progress/400 Data Dictionary
The Progress/400 Data Dictionary is a graphical environment on the client that allows you to modify DB2/400 data definitions and perform administrative functions on DB2/400 database files. Based on the standard Progress Data Dictionary, the Progress/400 Data Dictionary includes the same features. In addition, it has utilities for dumping and loading data and data definitions. You can use the Progress/400 Data Dictionary to modify, add, or delete tables, fields, indexes, sequences, and stored procedures.
The Progress/400 Data Dictionary is fully integrated into the Progress Application Development Environment (ADE). You access it from the DataServer menu in the Data Administration tool.
Figure 9–1 shows the Progress/400 Data Dictionary window.
Figure 9–1: Progress/400 Data Dictionary Window
![]()
The Progress/400 Data Dictionary allows you to define Progress features that are not supported by DDS, such as field labels, display formatting, triggers, validation expressions, validation messages, help strings, arrays, data types, and case-insensitive indexing. You can also provide descriptions (up to 50 characters long) of objects.
NOTE: If DB2/400 database files contain DDS definitions that the DataServer does not support, do not use the Progress/400 Data Dictionary to maintain or modify them. Continue to maintain the database files through DDS. You can use the Progress/400 Data Dictionary to view the supported subset of data definitions and generate reports on them.The Progress/400 Data Dictionary supports word indexes, generally in the same manner as the Progress Data Dictionary does. Minor differences are noted, where relevant, in this chapter. For general information on word indexes, see the Progress Programming Handbook.
Before you can use the Progress/400 Data Dictionary to access DB2/400 database objects, you must create a Progress/400 Dictionary Library on the AS/400 that includes the server schema for those objects. See "Creating the Progress/400 Environment," for detailed instructions.
The Progress/400 Data Dictionary operates in two modes:
- Modify schema — This mode requires that the client session connect to the AS/400 server as Database Administrator (DBA) and that the current user have authority to execute the Change Journal (CHGJRN) CL command. When you access DB2/400 database files in DBA mode, the OS/400 locks the objects and prevents other users or jobs from accessing them. Use this mode only when you plan to make changes to DB2/400 data definitions.
- Read only — This mode allows you to view DB2/400 data definitions; load data; and generate table, field, index, and sequence reports. It does not lock the server schema.
You must synchronize the client schema holder with the server schema before performing any tasks with the Progress /400 Data Dictionary that involve dumping or loading data. You do not have to synchronize before modifying, dumping, or loading data definitions.
Alternate between modify-schema mode and read-only mode by activating the appropriate radio button in the Progress/400 Data Dictionary main window.
Be sure to commit changes that you make when you move from modify-schema mode to read-only mode in the Progress/400 Data Dictionary. If you select not to commit changes, the DataServer rolls back any uncommitted changes.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |