ODBCLink/SE Reference Manual | Appendix B Creating a DBEnvironment |
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:
⊗Login to the directory where you want to create the DBEnvironment.
⊗From the C shell, enter the following command: $ /usr/lib/allbase/hpsql/sqlsetup
•From the Korn shell or Bourne shell, enter the following command:
$ csh /usr/lib/allbase/hpsql/sqlsetup
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=>
⊗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! Press Return to continue...
⊗Choose 0 to exit the menu.
If you have designed your own database for testing purposes, you can consult your database administrator and complete the following tasks:
⊗Plan the security structure of the DBEnvironment. Decide which users will be granted access to the DBEnvironment, databases within the DBEnvironment, and tables within the databases.
⊗Create the directory where the DBEnvironment is to reside.
ODBCLink/SE |
|
©M.B. Foster Associates Limited | 73 |
