Defining a Database Using Non-SQL › Defining a Schema › AREA Statements

AREA Statements

AREA statements identify an area of the database. Depending on the verb and options coded, the AREA statement can also:

• Add, modify, delete, display, or punch the area description
• Determine which (if any) database procedures will be executed when the area is accessed at runtime

The schema compiler applies AREA statements to the current schema. See 9.7, “Establishing Schema and Subschema Currency”.

The ADD AREA statement causes CA IDMS/DB to create a new area description in the dictionary and associates it with the current schema.

Procedure

1. Name the area
2. Optionally specify database procedures to be called

Note: You can copy an area description from another schema

Example

The following example shows an AREA statement including calls to database procedures:

add area name is org-demo-region
    call secdbproc before ready for exclusive update
    call chkdbproc before rollback.

SAME AS

SAME AS copies an entire area description including database procedure information from an area in another schema into the current schema. The SAME AS clause must precede all other optional clauses.