MAKEDB

Sets up/modifies the data dictionary.

See Creating a Database in the DP4 Developer's Manual for further information about this program.

Command Tail Description
−DATA Data independence is invoked for all tables as though they contained data.

−DIRECT

Prevent MAKELINK from creating new indirect index links

−DISTANCE n

Create MAKELINK links up to distance n. (The default is 4)

−EXPERT

Set up additional information (select tables for local access on a network, hashed index or non-unique keys, use the PHYS_INDEX index, store data without padding)

−LINK

Perform MAKELINK as you go along

−NOCOPY

Suppress copying of the Base Dictionary if the database does not exist (for example for use in networks)

−NONEWINDEX

Any new direct secondary indexes are created with the index disabled. SETLINK must be used to enable the new indexes that are required. This will avoid the unnecessary creation of secondary indexes.

−NOISY

Verbose Makelink phase (this slows it down a lot)

−USER

Restrict operation to cosmetic changes

For exporting database structure:
−AUTODEFAULT Include default values of autoincrement fields in print out.
Normally this is omitted so that the default is taken from the value on the target database.

−EITHER

When extracting selected tables, include index information if either the child or parent table is one of the extracted tables. The default behaviour only includes indexes where both tables are extracted tables, which is usually not helpful.

For posting database structure:
−BYNUMBER Number to take precedence over name in Table/Field matching