Extract Naming and Numbering

Database Numbers

An extract has the same database number as the primary database. This means that no Multiple Database (MDB) or Database (DB) Set can contain more than one database in the same extract family (but see Working Extracts, Types of Extracts).

Extract Numbers

Each extract, including the primary, has an extract number which is unique in the extract family. When an extract is made, the primary database itself becomes an extract, and the primary extract will always have extract number 1. By default, each extract will have an extract number allocated sequentially as it is created. The user can specify a particular extract number on the Create Extract window.

Before the user starts creating extracts, they should work out an extract numbering system, and set the extract numbers explicitly when the extracts are created.

Each extract DB is stored in a separate file. The filename of an extract is of the form:

prjdddd_eeee

where: prj is the project code

dddd is the database number

eeee is the extract number

For example, extracts of a database with filename xyz0099 will have filenames xyz0099_0001, xyz0099_0002, and so on.

Extract numbers must be between 1 and 8191 inclusive, for each extract family.