|
|
Getting Started with HP IMAGE/SQL: HP 3000 MPE/ iX Computer Systems > Chapter 6 Practicing with IMAGE/SQL Using MusicDBESetting Up MUSIC and MusicDBE |
|
This section shows you the steps to set up the database and DBEnvironment. Before beginning, change into the group and account where you want to create MUSIC and MusicDBE. For clarity, use an empty group, if possible. This chapter uses the group PUB and the account ACCOUNT. A script is provided with the IMAGE/SQL product that simplifies the database creation and purging processes. To execute the script, type:
A menu like the one in Figure 6-1 “SQLSetup Menu” appears on your screen (some details may differ on your system). Figure 6-1 SQLSetup Menu
The options are described in Table 6-1 “Menu Options”. Table 6-1 Menu Options
From the above menu, select Option 1 to create the TurboIMAGE/XL MUSIC database in your group and account. Next, select Option 3. This will execute IMAGESQL.PUB.SYS, set the TURBODB parameter to MUSIC, and set the SQLDBE parameter to the non-existent MusicDBE. The DBE will be automatically created for you at this time. This option then attaches MUSIC to MusicDBE. When you return to the menu, select Option 0 to exit. After completing Options 1 and 3, list the files in the current group and account. You will find the following files in your group:
The files are all PRIV files, which means you cannot purge them without special system authority. The DBUTIL and SQLUtil utilities provide this authority. |
|