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:

Follow these steps to modify data definitions using the Progress/400 Data Dictionary:

  1. Make sure that all users disconnect from the database. The database locks until changes are either rolled back or committed.
  2. Make a backup copy of your server schema and data files.
  3. From the client machine, connect the client schema holder and its DB2/400 database.
  4. 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."
  5. 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.

  6. If you want to commit your transaction, run Edit Commit Transaction to update the modifications in the server schema.
  7. 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 make a mistake or want to undo your changes, run Edit Undo Transaction.

  8. Change to Read Only mode in the Progress/400 Data Dictionary.
  9. 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