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