Progress/400
Product Guide
Loading Data Definitions
You use the Progress/400 load utility to move your Progress database to the AS/400 after you create the server schema. Note that when you load Progress-formatted or AS/400-formatted data definitions into DB2/400 database files, you lose any DDS definitions in the DB2/400 database files that the DataServer does not support. (See the Progress/400 Release Notes for a list of supported DDS keywords.)
Follow these steps to load data definitions into the server schema:
- Access the Progress/400 Data Dictionary and choose Modify schema.
- Choose Admin
Load Data & Definitions
Data Definitions (.df).
The following dialog box appears:
![]()
- Enter the name of the data definitions (.df) file that you want to load.
You cannot load a .df file of a type other than AS/400 or Progress (for example, ORACLE).
You can load a standard Progress .df file (including an incremental .df file) or an AS/400-formatted .df file. If you load a standard Progress .df file, the utility adds the information required by the AS/400, such as field storage length and DDS data type.
CAUTION: Use the Progress/400 Data Dictionary to load a .df file. Additionally, if you load an AS/400-formatted .df file that you have modified by hand, unpredictable results can occur.Table 9–4 describes how the utility maps Progress data types to DDS and DB2/400 data types. See the "Data Types" section in "Common Product Information," for more information.
- Activate a toggle box to select how the load utility handles errors and warnings. Even if you do not choose to display errors on screen, the utility displays serious errors; that is, errors that prevent the load from continuing or backing everything out.
- If you want all file and field names to be RPG compliant, activate the Create RPG/400 Length Names toggle box.
- If you want all fields to be SQL Null Capable, accept the default value, otherwise deactivate the Allow SQL Null toggle box.
- Choose OK.
If the .df file contains an index the length of whose combined fields is greater than or equal to 200, the load utility does not create the index. However, the load utility continues to load the valid definitions and displays messages about definitions that it could not load.
Loading a definition file that contains word indexes creates an index with a default word size of 30.
NOTE: You can change the word size in the Index Properties dialog box, but only before you commit the word index. Once you commit it, you can change the word size only by deleting and re-creating the word index. Similarly, you can change the attributes of a field in the Field Properties dialog box, but only before you commit the file. Once you commit it, the Progress/400 Data Dictionary restricts what attributes you can change.If the .df file contains virtual file definitions, the load utility creates physical files. For example, when you dump definitions for a logical join named CUSTJ1 and load it, the DataServer creates a physical file CUSTJ1 and a logical file CUSTJ1__1 for the primary index. See the "Virtual Tables" section in "Common Product Information," for more information.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |