How Databases are Stored

Each database is a separate file, stored in the Project Directory. The filenames have the format:

xxxnnnn_mmmm

where xxx is the Project Code, for example, abc, and nnnn is a number from 1 to 6999. nnnn is the database number and mmmm is the extract number. By default, the databases are given the next available number, but the user can specify what number will be used when the user creates the database; refer to Create Databases.

Databases can be stored in a different area, that is a different directory from the Project directory. This may be necessary, for example, if disk space is a problem. The directory must be created before the database is created, and an environment variable set, for example:

xxxnnn   set to     pathname

where xxx is the Project Code, for example, abc, and nnn is the area number which must be in the range from 1 to 999, for example, 001. When the database is created, the area number of the database must then be set to the corresponding value, in this example, 1.

For information about Extract database files, refer to Multiwrite Databases and Extracts.