Download Reference Manual

Transcript
Appendix B - Creating a DBEnvironment
On the HP9000 Database Server
On the HP9000 Database Server
To enable a connection between a PC client and database server, you must set up an ALLBASE/SQL
DBEnvironment. If you do not have an existing database for testing purposes, you can use the
ALLBASE/SQL SQLSetup tool to create a DBEnvironment called PartsDBE.
Follow these steps to create the PartsDBE database on the HP9000:
1. Login to the directory where you want to create the DBEnvironment.
2. From the C shell, enter the following command:
Return
$ /usr/lib/allbase/hpsql/sqlsetup
From the Korn shell or Bourne shell, enter the following command:
$ csh /usr/lib/allbase/hpsql/sqlsetup
Return
A menu like the following will appear on your screen:
Options for Setting Up ALLBASE/SQL Sample DBEnvironments
=======================================
Choose one:
1. Create PartsDBE without sample programs
2. Create PartsDBE, copy, preprocess and compile sample programs
3. Copy, preprocess and compile sample programs only
4. Generate a schema for PartsDBE
5. Display schema for PartsDBE
6. Purge PartsDBE and sample programs
7. Help
0. Exit
========================================
Enter your choice=>
Figure 39
3. Choose option 1 to create PartsDBE. This option creates the DBEnvironment, defines all of
its tables, views, indexes, and security structure, and then loads it with data. As the system
creates PartsDBE, you see several messages displayed. At the end of the creation process,
you see the following message:
Creation and Loading of PartsDBE is now complete!
ODBCLink/SE
© M. B. Foster Software Labs Inc., 1996-1998
Page 81