ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 327
SQL Statements A - D
CREATE DBEFILE
CREATE DBEFILE
The CREATE DBEFILE statement defines and creates a DBEFile and places a row
describing the file in SYSTEM.DBEFile. A DBEFile is a file that stores tables, indexes,
hash structures, and/or LONG data.
Scope
ISQL or Application Programs
SQL Syntax
CREATE DBEFILE DBEFileName WITH PAGES = DBEFileSize , NAME = ‘SystemFileName’
[, INCREMENT = DBEFileIncrSize [, MAXPAGES = DBEFileMaxSize ]]
[, TYPE = {TABLE
INDEX
MIXED}]
Parameters
DBEFileName is the logical name to be assigned to the new DBEFile.
Two DBEFiles in one DBEnvironment cannot have the
same logical name.
DBEFileSize specifies the number of 4096-byte pages in the new
DBEFile. The minimum DBEFile size is 2 pages. The
maximum DBEFile size is 524,287 pages.
SystemFileName identifies how the DBEFile is known to the operating
system. The system file name is in the format
[
Pathname/ ] FileName . The DBEFile is created relative
to the directory where the DBECon file resides unless an
absolute path name is specified. The maximum length for
SystemFileName is 44 bytes.
DBEFileIncrSize is a number you must supply with the INCREMENT
clause when you want to expand the DBEFILE. The
DBEFileIncrSize should be 8 pages or greater but it
cannot exceed 65,535. No system default is provided by
ALLBASE/SQL; if this number is omitted, no DBEFile
expansion takes place.
DBEFileMaxSize is a number that you can supply with the MAXPAGES
clause if you have already specified a
DBEFileIncrSize .
If the
DBEFileMaxSize is not a multiple of
DBEFileIncrSize , the number may be rounded up or
down as follows: The smallest higher multiple is tried first.
If the smallest higher multiple is not a valid size, the
largest lower multiple is used. A warning message is
returned to let you know that the
DBEFileMaxSize is