Manage default areas
- Last Updated: January 26, 2026
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation
The Data Dictionary supports updating (set/reset) defaults area for table/index/lob. from DB properties dialog box (only in GUI). For more information, see Show default areas for creating database objects in Manage the OpenEdge Database.
You can load objects into default areas using a data definition file (.df).
For example, this sample file loads tables, lobs, and indexes into default areas.
ADD TABLE "tab1"
AREA "Table Area"
DUMP-NAME "tab1"
ADD FIELD "id" OF "tab1" AS integer
FORMAT "->,>>>,>>9"
INITIAL "0"
POSITION 2
MAX-WIDTH 4
ORDER 10
MANDATORY
ADD FIELD "name" OF "tab1" AS character
FORMAT "x(8)"
INITIAL ""
POSITION 3
MAX-WIDTH 16
ORDER 20
ADD FIELD "clob1" OF "tab1" AS clob
FORMAT "x(8)"
INITIAL ?
POSITION 4
LOB-AREA "Lob Area"
LOB-BYTES 104857600
LOB-SIZE 100M
CLOB-CODEPAGE "iso8859-1"
CLOB-COLLATION "basic"
CLOB-TYPE 1
ORDER 30
ADD FIELD "blob1" OF "tab1" AS blob
FORMAT "x(8)"
INITIAL ?
POSITION 5
LOB-AREA "Lob Area"
LOB-BYTES 104857600
LOB-SIZE 100M
ORDER 40
ADD INDEX "idx1" ON "tab1"
AREA "Index Area"
PRIMARY
INDEX-FIELD "id" ASCENDING
.
PSC
cpstream=ISO8859-1
.
0000000795
Note: If
.df is generated with previous OpenEdge version that did not
support default areas, but loaded with a version that supports them, database
objects will load into default areas. When the default area is not set and area is
not mentioned in .df file, then tables and indexes are assigned to
schema area and LOB field assigned to the table’s area.