TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

432 Chapter8
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 has been ERASED
>>