TurboIMAGE/XL Database Management System Reference Manual (30391-90012)

424 Chapter8
Using the Database Utilities
>>CREATE
>>CREATE
Creates and initializes a file for each data set in the database.
Once the Schema Processor has created the root file, the database creator must build a file
for each data set in the database using the >>CREATE command. DBUTIL initializes each
data set to zeros and saves it as a catalogued MPE/iX file in the same logon group as the
root file, on the device classes specified in the schema. The data set names are created by
appending two digits to the root file name. If the root file is named XXXX, then the first
data set defined in the schema is named XXXX01, the second data set is named XXXX02,
and so on. In order to save files for the maximum of 240 data sets per database, files are
incremented from XXXX01-99, XXXXA0-A9, XXXXB0-B9, up to XXXXO0.
To execute the DBUTIL program to create and initialize the database, you must be the
database creator; that is, you must log on with the same user name, account and group
that was used to run the Schema Processor and create the root file. After DBUTIL has
created and initialized the database files, it prints a confirmation message on the list file
device and prompts for another command.
The CREATE command has been enhanced to create the required chunk control and chunk
data files for jumbo data sets. To specify a jumbo data set, the JUMBO option must be
included in the schema before defining a jumbo data set. Then any data set whose capacity
is greater than 4GB automatically becomes a jumbo data set.
The CREATE command does an implicit ADDINDEX command for each dataset marked by
DBSCHEMA as indexed.
Syntax
>>C[REATE] database name [/ maint word ]
For example:
CREATE ORDERS
where ORDERS is the database name .
Parameters
database name is the name of a TurboIMAGE/XL database being created.
maint word is the maintenance word that can be defined by the database creator when
the database is created. To access the database, anyone other than the
database creator must supply this word.