Progress/400
Product Guide
Modifying Data Definitions Using the Progress/400 Data Dictionary
Before you modify DB2/400 definitions that were created using the Progress/400 Data Dictionary or that contain Progress-specific properties, consider the following information:
- When you use the Progress/400 Data Dictionary in Modify Schema mode, journaling on the server schema objects (P__*) starts automatically using the journal PRODBAJRN. This allows you to roll back server schema changes before they are committed.
- Do not journal server schema objects to another journal. Also, you cannot move PRODBAJRN to another library.
- The user profile that you use to connect to the DB2/400 database must have *ALLOBJ authority to make database modifications using the Progress/400 Data Dictionary. IBM’s API for Progress/400 requires this authority and cannot be changed by Progress/400.
- Do not change the object authority or location of any objects Progress/400 creates in the server schema library.
Follow these steps to modify data definitions using the Progress/400 Data Dictionary:
- Make sure that all users disconnect from the database. The database locks until changes are either rolled back or committed.
- Make a backup copy of your server schema and data files.
- From the client machine, connect the client schema holder and its DB2/400 database.
NOTE: If you add or modify triggers that reference tables, fields, or indexes that are not committed and synchronized, you get an error message when you attempt to compile the code. This occurs when you activate the Check Syntax or Check CRC toggle box. You can save the trigger code, but you must commit transactions and synchronize the client before the code will compile successfully.- Enter your schema changes using the Progress/400 Data Dictionary’s Modify Schema mode. For more information on how to modify, add, and delete tables, fields, and indexes, see Remote Client DB2/400 Utilities."
NOTE: The commit process does the following on the AS/400: starts a job named APYPRODCT, creates a DDS for the new or modified table, and saves and restores data to modified tables. If anything fails during the commit process, the server schema is automatically restored to its previous state.- If you want to commit your transaction, run Edit
Commit Transaction to update the modifications in the server schema.
If you make a mistake or want to undo your changes, run Edit
Undo Transaction.
- Change to Read Only mode in the Progress/400 Data Dictionary.
- From the Data Administration menu, run Synchronize Progress/400 Client to update the client schema holder.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |