Using The Practical SQL Handbook CD 

1. This CD contains 
* a 60-day trial version of Sybase Adaptive Server Anywhere
* the bookbiz sample database used in the book
* the readPSH4.txt file with these instructions
* files to create the bookbiz tables on other DBMS systems 
  (MS SQL Server, Oracle, Informix, and Sybase Adaptive Server 
  Enterprise -- software for these DBMSs is not, however, supplied
  on the CD)

2. To load Adaptive Server Anywhere, insert the CD in your drive. 
If an installation program does not come up immediately, 
choose the correct platform directory from the Anywhere directory 
(CE, Netware, Win16, or Win32) and start the setup.exe file. 
Follow the installation directions. For those short of space, 
Personal Server is the minimum. Sybase Central and Help files are useful 
additions.

3. Once you have installed Adaptive Server Anywhere, use the Windows 
Explorer (or similar utility) to copy the bookbiz.db file from the CD 
to your hard drive. (For a copy of these instructions, print the 
readPSH4.txt file from the CD.)

4. Start Adaptive Server Anywhere/Interactive SQL (from the "Programs" menu
 on Windows, or according to the customs of your system).

5. The "Connect to Adaptive Server Anywhere" window opens. 
(If it does not, type "connect" in the "Command" pane at the bottom third 
of the Interactive SQL window and click "Execute". This will bring up 
the "Connect to Adaptive Server Anywhere" window.)

6. Type "DBA" (must be uppercase) in the login line, and "SQL" in the
password 
line.

7. Without clicking the "OK" button, click the "Database" tab at the top 
of the form.

8. Type "bookbiz" in the "Database name" line. Give the full path name 
of bookbiz.db in the "Database file" line. (See step 3. If you copied the
bookbiz.db file to C:/SQL, for example, the address for "Database file" is
C:/SQL/bookbiz.db.).  

9. Click "OK" at the bottom of the form. The heading in the top border 
of the "Interactive SQL" window indicates you are DBA, on bookbiz. 
The bookbiz database is already built and ready to go.

10. Type a sample query, such as "select * from publishers" in the 
Interactive SQL "Command" pane. When you click the "Execute" button, 
the results appear in the "Data" pane at the top of the 
"Interactive SQL" window. 

11. Use Sybase Central (it may be listed as "Manage Adaptive Server 
Anywhere" in the "Programs" menu) for adding users, checking table column 
definitions, etc. Log into Sybase Central by picking the "Connect" 
option on the Sybase Central "Tools" menu. The "Connect to Adaptive 
Server Anywhere" window opens. Follow the process described in steps 6-9 
above.

12. Scripts to create table, add data, and create views are included 
in the CREATEs, INSERTs, and VIEWs directories on the CD, and directions 
for using them are in the scripts and in Appendix A. Use these files if 
you want to restore after removing tables or deleting data.  

13. Scripts for creating bookbiz tables for other RDBMSs (Oracle, 
SQL Server, Informix, and Sybase ASE) are also included on the CD, in
the CREATEs, INSERTs, and VIEWs folders.