Progress
Database Administration
Guide and Reference
PRODB Utility
Creates a new Progress database.
PRODB 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.
SYNTAX
Operating System Syntax UNIXWindows prodb[
new-db-name
]
[empty
|sports
|isports
|sports2000
|old-db-name
|demo
]
new-db-name
Specifies the name of the database you are creating. If you specify a directory without a filename, Progress returns an error.
The value you specify can be any combination of letters and numbers, starting with a letter. Do not use Progress 4GL keywords or special characters, such as commas or semicolons. The maximum length of new-db-name varies, depending on the underlying operating system. For specific limits, see Progress Database Limits."
empty
Specifies that the new database is a copy of the
empty
database located in the Progress install directory. PRODB knows where to locate theempty
database, so you do not need to provide a pathname to it.In addition to the default
empty
database, PRODB allows you to create other empty database structures with different block sizes:sports
Specifies that the new database is a copy of the Progress Sports database.
isports
Specifies that the new database is a copy of the Progress international Sports database.
sports2000
Specifies that the new database is a copy of the Progress Sports2000 database.
old-db-name
Specifies the name of the database you are copying.
demo
Specifies that the new database is a copy of the Progress demo database.
NOTES
- You can also create a new database from the Progress Data Dictionary.
- When you use the PRODB utility and give the copy a new name, you cannot run the original r-code against the new database. This is because Progress saves the database with the r-code. To run the r-code against the new database, use the Logical Database Name (-
ld
) startup parameter and use the original database name.- A new database must contain the same physical structure as the source. For example, it must have the same number of storage areas, records, blocks and blocksize.
- PRODB supports the use of internationalization startup parameters such as
-cpinternal
codepageand
-cpstream
codepage. See "Database Startup Parameters," for a description of each database-related internationalization startup parameter.- When issuing the PRODB command, specify the target and source database names (they are positional) before specifying an internationalization startup parameter such as
-cpinternal
.- PRODB also supports the parameter file
(-pf
) startup parameter that contains a list of valid startup parameters.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |