Progress/400
Product Guide
Creating a Database Using Existing DB2/400 Data
This section explains how to create a database when your Progress/400 application uses existing data files; for example, from an RPG application. For more information, see Creating the Progress/400 Environment."
Follow these steps:
- Create an empty server schema on the AS/400 by running the DUPPRODB utility. Table A–2 notes the required DUPPRODB parameter values; additional parameters are optional.
See "AS/400 Utilities," for more information on the DUPPRODB utility.
- Add the existing data files to the Progress/400 server schema by running the Progress/400 CHGPRODCT utility. Table A–3 notes CHGPRODCT parameter values to use.
When using this utility, note the following:
- If you enter a specific library name for the From Library(s) parameter and want to add files from other libraries to the server schema, 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.
- Create a client schema holder 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 |