Progress/400
Product Guide


Modifying Data Definitions Using an AS/400 Tool

This section explains how to modify data definitions that were created using an AS/400 tool or that contain AS/400-specific properties such as DDS keywords.

NOTE: If you use this method to modify data files, you might lose Progress data files properties when you run CHGPRODCT, unless you use the RTNPROATR parameter.

To use this method, follow these steps:

  1. Run CHGPRODCT to update the server schema. Table A–7 notes CHGPRODCT parameter values to use.
  2. Table A–7: CHGPRODCT Selections to Update Server Schema 
    Parameter
    Option
    PRODCT(library name)
    Enter the library name where the server schema is located or enter *CURLIB.
    FRMFILLST
    Enter a list of the data physical files you have added, modified, or deleted. Enter *ALL to update definitions for all files in a specific library. This utility automatically picks up the related logical files if you set the Include Database Relations parameter to *YES.
    From library(s)
    Enter a specific library name or enter *LIBL if the data files are in multiple libraries.
    Include Database Relations
    Enter *YES, the default, to preserve the logical file dependencies.
    PROATR
    Enter *YES to preserve Progress data-file properties.
    FRCCHG
    Enter *SAVE to preserve non-Progress data-file properties such as select/omit.
    ERRLIMIT
    Enter *NOMAX to specify that the utility continue to run when an error occurs.

    When using this utility, note the following:

    • If you enter a specific library name for the From Library(s) parameter and want to update definitions for data files in other libraries, run CHGPRODCT again for each additional library.
    • If you enter *YES to Include Database Relations, CHGPRODCT automatically picks up related logical files in other libraries without specifying the other library names.
  3. Create a new client schema holder or synchronize an existing one for the server schema. See "Remote Client DB2/400 Utilities," for more information on client utilities.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095