IMPORTANT INSTALLATION INSTRUCTIONS AND NOTES FOR 
SYBASE SQL ANYWHERE RUNTIME 

Please read through these notes completely before installing
the runtime version on your computer.  We suggest that you 
print this file and have it available for reference during
the installation process.


------------------------------------------------------------

CONTENTS

1.  Note to current users of Sybase SQL Anywhere
2.  Installation instructions
3.  Running the program and using the bookbiz database
4.  A note on the 'bookbiz.sql' script


------------------------------------------------------------

1.  NOTE TO CURRENT USERS OF SYBASE SQL ANYWHERE

When the install takes place, it overwrites any files 
currently in the C:\sqlany50 subdirectory.  If you have 
already installed a current version of Sybase SQL Anywhere,
this program may overwrite updates with the original files.
To avoid potential problems, install this runtime in a 
different subdirectory, for example c:\sqlanyqq.  Substitute
this subdirectory for the \sqlany50 subdirectory throughout
the installation and use instructions.

If you already have the *full* version of Sybase SQL 
Anywhere 5.0 (that is, if you already have the Interactive
SQL interface), we recommend that you not install the 
runtime and instead proceed directly to Part 3, "Running the 
program and using the bookbiz database."


------------------------------------------------------------

2.  INSTALLATION INSTRUCTIONS

Insert the CD in your CD-ROM drive.

From My Computer or the File Manager, choose the CD drive
by letter (often 'D') or icon to get a list of the 
subdirectories on the CD-ROM.  They are:

   \EXAMPLES   \WIN3X   \WIN95   \WINNT

There is a separate 'setup.exe' program in the subdirectory
for each operating system.

Choose the 'Run' command from the Start button on Windows 95,
or from the File Manager File menu on Windows 3.x and 
Windows NT.  At the command line type the complete path for
the setup program for your operating system.  For example,
if you are running Windows 95 and your CD-ROM drive is 
labeled D, you type: D:\WIN95\setup.  If you are running
Windows NT and your CD-ROM drive is labeled E, type:
E:\WINNT\setup.

Follow the instructions on the screen to complete the 
installation of the program.  If you do not already have
another version of Sybase SQL Anywhere installed on your
computer, we recommend that you accept the default 
settings and don't bother loading the DLLs for 3.2 and
4.0.

Reboot (shut down and re-start) your computer.


------------------------------------------------------------

3.  RUNNING THE PROGRAM AND USING THE BOOKBIZ DATABASE

Copy the files 'bookbiz.db' and 'bookbiz.sql' from the 
\EXAMPLES subdirectory on the CD-ROM to the directory on 
your hard drive where the file 'sademo.db' is located.  On 
Windows 95 and Windows 3.x systems, this will be the 
\sqlany50 subdirectory.  On Windows NT, it will be 
\sqlany50\win32.

To use the bookbiz database, click on the 'isql' file or 
icon.  (On Windows 3.x and Windows NT, this will be in the 
Sybase SQL Anywhere program group in the Program Manager.  
For Windows 95, it can be found off the Start menu in the 
Sybase SQL Anywhere folder on the Programs menu.)

When the three-panel Interactive SQL window opens, type
'connect' in the Command panel at the bottom of the screen
and click the 'Execute' button.

An Interactive SQL Logon window opens.  Fill in the form
using the values shown here:

         User ID:        DBA
         Password:       SQL
         Connection:
         Database Name:  bookbiz
         Database File:  <complete path of bookbiz.db --
                          for example, 
                          C:\sqlany50\bookbiz.db, or
                          C:\sqlany50\win32\bookbiz.db>
         Server:
         Startline: 

Leave Connection, Server, and Startline blank.

Click OK.  This will return you to the Interactive SQL 
Window. 

When the 'Execute' button in the Command panel becomes 
available, erase the 'connect' command by backspacing over 
it or by picking the New option from the File menu at the
top of the window.

Type in a test command, such as:

     select *
     from publishers

and click the 'Execute' button.  The results of the 
query appear in the top Data panel.

You're ready to run all the queries in the Practical
SQL Handbook!


------------------------------------------------------------

4.  A NOTE ON THE 'BOOKBIZ.SQL' SCRIPT

The 'bookbiz.sql' file is provided to help you re-create the 
bookbiz database on non-SQL Anywhere systems.  It is 
provided for your reference only and is not guaranteed to 
work with other versions of SQL.  Some editing may be 
necessary to conform to the specifics of your system.