ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 293
SQL Statements A - D
ADD DBEFILE
ADD DBEFILE
The ADD DBEFILE statement updates a row in SYSTEM.DBEFile to show the DBEFileSet
with which the file is associated.
Scope
ISQL or Application Program
SQL Syntax
ADD DBEFILE DBEFileName TO DBEFILESET DBEFileSetName
Parameters
DBEFileName is the name of a DBEFile previously defined and created
by the CREATE DBEFILE statement.
DBEFileSetName is the name of a previously defined DBEFileSet. You can
use the CREATE DBEFILESET statement to define
DBEFileSets.
Description
• You cannot insert any rows or create any indexes for a table or put any non-null values
in a LONG column until the DBEFileSet it is located in has DBEFiles associated with
it.
• You can add DBEFiles to the SYSTEM DBEFileSet.
• Before a DBEFile can be added to the SYSTEM DBEFileSet, other users' transactions
must complete. Other users must wait until the transaction that is adding the DBEFile
to SYSTEM has completed.
• ADD DBEFILE increases the number of files associated with the DBEFileSet shown in
the DBEFSNDBEFILES column of SYSTEM.DBEFileSet by one.
Authorization
You must have DBA authority to use this statement.
Example
CREATE DBEFILE ThisDBEFile WITH PAGES = 4,
NAME = 'ThisFile', TYPE = TABLE
CREATE DBEFILESET Miscellaneous
ADD DBEFILE ThisDBEFile TO DBEFILESET Miscellaneous
The DBEFile is used to store rows of a new table. When the table needs an index, a