Previous Topic: SYNONYMS StatementNext Topic: SCHEMA Statement


AREA Statement

The AREA statement allows you to specify the CA IDMS/DB database area(s) to which CA IDMS/DB records replacing Total files are assigned.

When generating schema record descriptions, the generator assigns each record type to the first area identified in the SCHEMA statement. The AREA statement permits you to override this default by naming specific Total files and the database areas to which corresponding CA IDMS/DB records are assigned.

Syntax

The following is the syntax for the AREA statement. You must specify the keyword AREA in column 1, idms-area-name in column 8, and total-file-name in column 12. The keyword and each variable must occupy an entire line.

►►── AREA ────────────────────────────────────────────────────────────────────►

                     ┌───────────────────┐
 ►── idms-area-name ─▼─ total-file-name ─┴────────────────────────────────────►◄

Parameters

AREA

Required keyword; must occupy a line by itself and begin in column 1.

idms-area-name

Specifies the name of a CA IDMS/DB database area to which CA IDMS/DB records corresponding to subsequently named Total files are assigned. Idms-area-name must be from 1 to 16 characters long, must occupy a line by itself, and must begin in column 8. Additionally, idms-area-name must be followed by at least one Total file name and must be named in the SCHEMA statement.

total-file-name

Specifies the name of a Total file. All occurrences of the CA IDMS/DB record type that correspond to this Total file are assigned to the database area indicated by idms-area-name. Total-file-name must be the name of a Total file defined in the input Total DDL. Total-file-name can be repeated as required, however each entry must occupy a line by itself, and must begin in column 12.

Example

The following is an example of the AREA control statement.

AREA
       CUSTOMER-REGION
           CUST
           REMA
           CUOR
           ACRE
           INVE
           DARE
           ORNU