Previous Topic: Creating a DatabaseNext Topic: Creating a Table

Creating SQL Objects › Creating an Area

Creating an Area

Use a CREATE AREA statement to define an area to CA Datacom/DB and CA Datacom Datadictionary within a specified database. These are data sets on a disk. There can be 1 to 240 areas within a single database. The upper limit of 240 areas is possible if only one table is created for each area).

For the steps to obtain the panel and an explanation of the fields on the panel, see How to Submit SQL Statements. Alternatively, you can use DBSQLPR or an external program to issue this statement. For the syntax of the statement, see CREATE AREA.

Use CREATE AREA to do the following:

  1. Specify the SQL Area Name. It must not identify a database, area, table, view, or synonym already described in the CA Datacom Datadictionary.
  2. Specify the database with which the area is to be defined. This is specified using the SQL database name.
  3. Specify the physical block size of the area in bytes. The valid minimum specification is 512 and the maximum is 32760 or track size, whichever is less.
  4. Specify the CA Datacom 3-character short name for the area. This name must be unique for all areas in the database.

For more information about the optional attributes that can be specified, see CREATE AREA.