ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 559
SQL Statements S - Z
START DBE NEW
AUDIT ELEMENTS as described above.
DBEFile0Definition is a clause that provides the information ALLBASE/SQL needs to
automatically create DBEFile0 and add it to the SYSTEM DBEFileSet.
The syntax for this clause is presented separately below. If
DBEFile0Definition is omitted, ALLBASE/SQL assumes the following:
DBEFILE0 DBEFILE DBEFILE0
WITH PAGES = 150,
NAME = 'DBEFile0'
By default, DBEFile0 resides in the same directory as the DBECon file.
However, you can use the SQLUtil MOVEFILE command to move it to
another directory.
DBELogDefinition is a clause that provides ALLBASE/SQL with the information
needed to create one or more log files. Syntax for this clause is presented
separately below. If
DBELogDefinition is omitted, ALLBASE/SQL
assumes the following:
LOG DBEFILE DBELOG1
WITH PAGES = 250,
NAME = 'DBELOG1
By default, DBELOG1 resides in the same directory as the
DBECon file.
SQL Syntax — DBEFile0Definition
DBEFILE0 DBEFILE DBEFile0ID
WITH PAGES = DBEFile0Size ,
NAME = '
SystemFileName1 '
Parameters — DBEFile0Definition
DBEFILE0 DBEFILE describes a DBEFile known as DBEFile0, which contains the portion
of the system catalog needed for activating a DBEnvironment, including
definitions of other DBEFiles. Each DBEnvironment must have a
DBEFile0 associated with a unique
SystemFileName , which is assigned
in this clause.
DBEFile0ID is the basic name identifying DBEFile0.
DBEFile0Size specifies the number of 4096-byte pages in DBEFile0. You can specify
from 150 to 524,287 pages. The default and minimum is 150.
SystemFileName1 identifies how DBEFile0 is known to the operating system. DBEFile0
is created relative to the directory specified in the DBEnvironment name
parameter unless an absolute path name is specified. The default file
name is 'DBEFile0'.