PREINIT (Pre-Format Index and Data Areas) › When to Use PREINIT data area

When to Use PREINIT data area

Use PREINIT data area when you want to pre-format and null load a data area that does not already exist.

PREINIT data area makes it possible for SQL to be used to create a table in a new area using the SQL statement CREATE AREA and, optionally, to create a table in a new database using the SQL statement CREATE TABLE. The table is then immediately loaded and available. The SQL create process can subsequently successfully complete. Without PREINIT, SQL can only create a table if that table is created as loaded into an area that already has another table in it, and for which the area has already been loaded.