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

Chapter 8 435
Using the Database Utilities
>>ERASE
>>ERASE
Reinitializes all data sets in the database to their empty condition and resets all flags
except the access, PREFETCH, and recovery flags (refer to the discussion of the DBUTIL
>>ENABLE command earlier in this chapter).
The data sets remain as catalogued MPE/iX files. To execute DBUTIL to reinitialize the
data sets, you must be the database creator or supply the correct maintenance word. This
utility function should be performed before data that was saved by DBUNLOAD is loaded
back into the database unless it was re-created.
After DBUTIL has completely reinitialized the data sets, it prints a confirmation message
on the list file device.
NOTE The ERASE command erases any associated B-Tree index (.idx) files, but will
not delete them.
Syntax
>>ER[ASE] database name [/ maint word ]
For example:
ERASE ORDERS/SELL
where ORDERS is the database name and SELL is the maint word .
Parameters
database name is the name of a TurboIMAGE/XL database being erased.
maint word is the maintenance word defined by the database creator
when the database is created with DBUTIL. This word
must be supplied by anyone other than the database
creator.
Example
:RUN DBUTIL.PUB.SYS Initiate DBUTIL execution.
.
.
.
>>ERASE ORDERS/SELL Enter >>ERASE command, database name, and
maintenance word.
Database ORDERS.MYGROUP.MYACCT has been ERASED
>>