To create a table in an alternate location, use the WITH LOCATION clause of the CREATE TABLE statement.

In Director, use the Options in the New Table tab. In VDBA, click Options in the Create Table dialog.

If you specify only one location, the entire table is stored in that location. If you choose more than one location, the table spans multiple locations. For example, if you designate two locations, the table is extended over two alternate locations. As rows are added to the table, they are added to each area in alternate blocks.

The blocks are:

The table is considered out of space if the next receiving area in turn does not have a sufficient block.