Progress/400
Product Guide


Creating a New Database with No Existing Data

This section explains how to create a new database with no existing data. Follow these steps:

  1. Create a new, empty server schema on the AS/400 by running the DUPPRODB utility. Table A–1 notes the required DUPPRODB parameter values; additional parameters are optional.
  2. Table A–1: DUPPRODB Parameter Values Required for No Existing Data  
    Parameter
    Option
    NEWDB(library name)
    Enter a library name or *CURLIB.
    FRMDB(*PROEMPTY)
    Use this empty server schema.
    OBJLIB(library name)
    Enter the library where data files defined with the Progress/400 Data Dictionary will be located. The default is *NEWDB, which puts the data files in the same library as the server schema. To put the data files in a separate library from the server schema, enter a library name.
    CRTLKT(*YES)
    Enter *YES if you want Progress locking behavior. You typically assign *YES if you are not accessing existing AS/400 data files with this server schema.

    See "AS/400 Utilities," for more information on the DUPPRODB utility.

  3. Create a client schema holder for the server schema. For more information on client utilities, see Remote Client DB2/400 Utilities."
  4. Define your database using either the Progress/400 Data Dictionary on the client machine or an AS/400 tool such as DDS. See the "Modifying DB2/400 Data Definitions with Progress/400" section for more information.

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