Progress
Database Administration
Guide and Reference
Creating a Database With the PRODB Utility
The PRODB utility creates a new database from a specified source database. PRODB creates a new database using the structure of the source database and places all of the extents in the current working directory. You can use PRODB to make a copy of any of the demonstration or empty Progress databases.
NOTE: When using PRODB to create a copy of a database, all the files of the database copy will reside in the same directory, unless you specify a structure description (ST) file for the target database.EXAMPLES
To create an empty database called
mysample
from a copy of the Progress default empty database, enter the following:
To create a new database called
mysports2000
from a copy of the Progress sports2000 database, enter the following:
To create a new database called
pastinfo
from a copy of an existing database namedcurrentinfo
, enter the following:
PRODB does not copy the external triggers associated with the database you are copying.
NOTE: See "Maintaining Database Structure," for information about changing pathname conventions when adding storage areas and extents to a structure description file.PRODB Maintains Pathname Convention
When you use the PRODB utility, the target database you create maintains the same pathname convention, relative or absolute, as the source database. For example, if you use PRODB to create a database and name it
example1
, and use a relative path database such assports2000
as the source database, PRODB maintains the pathname convention ofsports2000
(the source database), andexample1
(the target database) becomes a relative path database. Conversely, if the source database is an absolute path database, the target database you create with PRODB will also be an absolute path database. Use PROSTRCT LIST to verify whether the pathname is relative or absolute. For example:
In the following sample output of the PROSTRCT LIST utility, note the relative pathname of the database,
example1.db
:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |