The Unload utility
144
Use external unloading, external reload (–xx) This switch uses the
Interactive SQL OUTPUT statement to extract data from the database, and
uses the Interactive SQL INPUT statement in the generated reload command
file,
reload.sql
, to repopulate the database with data.
Operate without confirming actions (–y) Choosing this option replaces
existing command files without prompting you for confirmation.
To unload a database, start the database server with your database, and run
the Unload utility with the DBA user ID and password.
To reload a database, create a new database and then run the generated
reload.sql
command file through Interactive SQL.
In Windows 95/98 and NT, and UNIX, there is a file (
rebuild.bat
,
rebuild.cmd
, or
rebuild
) that automates the unload and reload process.
Rebuilding a
database
To Next Page
Loading...