PROSTRCT utility

Creates and maintains an OpenEdge database. For example, you can use PROSTRCT and its qualifiers to perform the following tasks:

Create a new database from an existing structure description (.st) file

Display storage usage statistics including information about storage areas in a database

Syntax

prostrct qualifier db-name [ structure-description-file ]
     [[-userid username [-password passwd ]]|
      [ -U username -P passwd]
     ]
     [-Passphrase]

Parameters

Specifies the qualifier that you want to use. You can supply the following qualifiers:

Details of the qualifiers are found in the PROSTRCT subsections listed in the following pages.

Specifies the database you are using.

Specifies the new .st file. Do not use dbname.st.

A pair of username and password parameters are used together to support a common user authentication model to specify the user ID and password when connecting to an OpenEdge RDBMS.OpenEdge authenticates the user ID and password against the user accounts defined by the authentication system configured for the user's security domain.

Use username and password parameters to identify an authenticated database administrator.

If you do not specify a user ID and password for a database connection, OpenEdge assigns the OS process's user-id as the default user-id.

For more information on authentication systems and security domains, see OpenEdge Getting Started: Identity Management.

For encryption-enabled databases only, specifies to prompt for a passphrase to authenticate the key store. Utilities that open the database must at a minimum authenticate as the key store user. See Transparent Data Encryption for more information on encryption and key store authentication.

Notes

You must define your database structure in a .st file before you create a database. PROSTRCT CREATE creates a database control (DB) area from the information in the .st file.

See Creatingand Deleting Databases for a complete description of structure description files and storage areas.

PROSTRCT supports the use of internationalization startup parameters such as -cpinternalcodepage and -cpstreamcodepage. See DatabaseStartup Parameters for a description of each database-related internationalization startup parameter.