ODBCLink/SE Reference Manual | Appendix B Creating a DBEnvironment |
Appendix B Creating a DBEnvironment
On the HP3000 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. If you are using IMAGE/SQL, you can use the IMSQL.SAMPLEDB.SYS command to create an IMAGE/SQL database called MusicDBE. For more information,
refer to Getting Started with HP IMAGE/SQL.
Follow these steps to create the PartsDBE database on the HP3000:
⊗Logon to the group and account where you want to create the DBEnvironment.
⊗From the command prompt, enter the following command:
:SQLSETUP.SAMPLEDB.SYS
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:
ODBCLink/SE |
|
©M.B. Foster Associates Limited | 71 |
