Home |
Previous Page | Next Page Getting Started with DB-Access > Creating and Working with the Demonstration Databases >
When you run the installation script for a demonstration
database, the script asks you if you would like to copy sample SQL command
files. Command files that the demo includes have a .sql extension
and contain sample SQL statements that you can use.
Always initialize or run DB–Access from the directory in which
you want to store SQL command
files for the following reasons:
- Each time you create or reinitialize the demonstration database,
the installation script prompts you to ask if you want a copy of
the sample command files provided with the demonstration
database saved in the current directory.
- DB–Access lists only the files that end in the extension .sql in
the current directory.
Command files are described in Appendix B. Demonstration SQL.
To prepare a demonstration database
- Create a new directory.
UNIX Only
You must have UNIX read
and execute permissions for each directory in the pathname that
you create.
End of UNIX Only
- Change directories to the new directory and run the initialization
script.
*** describes the various
database models available for each database server version. For
options that you can use with the initialization script, see Command-Line Syntax.
- The initialization script displays a series of messages on the
screen as the database is created. The final message of the script
prompts you to make a choice. If you want to copy the command files
into the directory that you created, press Y.
Tip:
If you want to discard changes that you made to your database
or to the command files, rerun the demonstration initialization
script. When the script prompt message displays, press Y to replace
the command files with the original versions.
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]