Physical Database DDL Statements › AREA Statements › Entity Currency › Examples

Examples

Mapping to a Single File

The CREATE AREA statement below defines an area that has only one associated file. All 100 pages in the area will map to the first available 100 blocks in the file.

create area demoseg.emp_space
   primary space 100 pages
   page size 4276
   within file demoseg.emp_file;

Mapping to Two Files

The CREATE AREA statement below defines an area that maps to two files. The first 500 pages in the area map to the first 500 blocks in the PUB_FILE_1 file. The second 500 pages in the area map to 500 blocks of the PUB_FILE_2 file, starting at block number 1001.

create area salesseg.sales_space
   primary space 1000 pages
   from page 85001
   maximum space 1500 pages
   page size 3820 characters
   page reserve size 800 characters
   within file pub_file_1
      from 1 for 500
   within file pub_file_2
      from 1 for 500;

Adding Pages to an Area

The ALTER AREA statement below adds 200 pages to the SALES_SPACE area. The new pages are mapped to the PUB_FILE_3 file.

alter area salesseg.sales_space
   extend space 200 pages
   within file pub_file_3
   from 1 thru 200;

Dropping an Area

The following DROP AREA statement deletes the definition of the SALES_SPACE area from the dictionary. If SALESSEG is defined as an SQL segment, then you must first drop all tables and indexes associated with the area:

drop area salesseg.sales_space;