Try OpenEdge Now
skip to main content
Database Administration
Database Basics : Creating and Deleting Databases : Creating a database with PROSTRCT CREATE : Create a database structure extent : Adding schema to a void database
Adding schema to a void database
When you use the PROSTRCT CREATE utility on a .st file, the resulting database files are referred to as a void database. A void database does not contain any OpenEdge RDBMS metaschema. 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 metaschema information to a void database. The OpenEdge RDBMS provides an empty database in the size of each supported database block size for this purpose.
To add metaschema information to a void database:
1. Copy the system tables from an empty OpenEdge database into the void database you created with PROSTRCT CREATE.
Use the PROCOPY utility as shown:
procopy OpenEdge-install-dir/emptyn db-name
Where emptyn is the source database and db-name is the target database. n indicates the block size of the OpenEdge-supplied empty.db. See PRODB utility for more information about the empty and emptyn databases.
2. Verify that you have the correct database files in the correct locations
Use the PROSTRCT LIST utility as shown:
prostrct list db-name
Caution: If you do not specify an output file when using PROSTRCT LIST, your existing file will be overwritten to reflect the current structure.
3. Use the Data Dictionary to load the existing user table definitions (.df file) into your database.
Caution: The empty .db file and the database you want copied to it must have the same block size. Similarly, if the blocks per cluster token is used with any data areas, the data areas of the empty .db file and those of the database you want copied to it must have the same blocks per cluster value.