Progress
Database Administration
Guide and Reference


Adding Schema To a Void Database

When you use the PROSTRCT CREATE utility on an ST file, the resulting database files are referred to as a void database. A void database does not contain any Progress metaschema information. The void database consists of the DB extent and whatever BI, AI, TL, and Dn extents you defined in the ST file. You must add Progress metaschema information to a void database. Progress provides an empty database in the size of each supported database block size for this purpose.

NOTE: The empty DB file and the database you want copied to it must have the same block size.

Follow these steps to use the PROCOPY utility to add Progress metaschema information to a void database:

  1. Use the PROCOPY utility to copy the system tables (the Progress metaschema) from a Progress empty database into the void database you created with PROSTRCT CREATE. On UNIX, use the following command syntax:
  2. procopy $DLC/emptyn db-name 
    

    On Windows, use the following command syntax:

    procopy %DLC%\emptyn db-name 
    

  3. Use the PROSTRCT LIST utility to verify that you have the correct database files in the correct locations. The following example uses PROCOPY and PROSTRCT LIST on UNIX:
  4. procopy $DLC/empty8 sports 
    prostrct list sports 
    

    The following example uses PROCOPY and PROSTRCT LIST on Windows:

    procopy %DLC%\empty8 sports 
    prostruct list sports 
    

  5. Use the Data Dictionary to load the existing user tables (DF file) into your database.

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