Extract Naming and Numbering

Administrator User Guide

Multiwrite Databases and Extracts : Creating Extracts : Extract Naming and Numbering

Database Numbers. An extract has the same database number as the master database. This means that no MDB or 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 master, has an extract number which is unique in the extract family. When an extract is made, the master database itself becomes an extract, and the master extract will always have extract number 1. By default, each extract will have an extract number allocated sequentially as it is created. You can specify a particular extract number on the Create Extract form.

•

Before you start creating extracts, you 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, etc.

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