HP 3000 Manuals

SQLUtil [ IMAGE/SQL Administration Guide ] MPE/iX 5.0 Documentation


IMAGE/SQL Administration Guide

SQLUtil 

SQLUtil contains two enhancements to support IMAGE/SQL:

   *   The ALL option of the SHOWDBE command displays the name of the
       ATCINFO file if any TurboIMAGE/XL databases are attached.
   *   If any TurboIMAGE/XL databases are attached and you purge the
       DBEnvironment, the PURGEDBE command automatically detaches them.

The following example illustrates these enhancements:
____________________________________________________________________________
|                                                                          |
|     :SQLUTIL                                                             |
|                                                                          |
|                                               SAT, MAY 12, 1990,  2:59 PM|
|     HP36216-02A.21.05             DBE Utility/3000             HP SQL/XL |
|     (C)COPYRIGHT HEWLETT-PACKARD CO. 1982,1983,1984,1985,1986,1987,1988, |
|     1989. ALL RIGHTS RESERVED.                                           |
|                                                                          |
|     >>SHOWDBE                                                            |
|     DBEnvironment Name: PartsDBE                                         |
|     Maintenance Word: usr                                                |
|     Output File Name (opt): Carriage Return                              |
|     -> ALL                                                               |
|                                                                          |
|     Maintenance word:                                                    |
|     DBEnvironment Language:  NATIVE-3000                                 |
|     AutoStart:  ON                                                       |
|     User Mode:  MULTI                                                    |
|     DBEFile0 Name:  DBEFILE0                                             |
|     Log File Name(s):  DBELOG1                                           |
|     Archive Mode:  OFF                                                   |
|     DDL Enabled:  YES                                                    |
|     No. of Runtime Control Block Pages:  37                              |
|     No. of Data Buffer Pages:  100                                       |
|     No. of Log Buffer Pages:  24                                         |
|     Max. Transactions:  2                                                |
|      TurboIMAGE Information File:  ATCINFO                               |
|                                                                          |
|     -> EXIT                                                              |
|                                                                          |
|     >> PURGEDBE                                                          |
|     DBEnvironment Name: SALESDBE                                         |
|     Purge DBEnvironment (y/n)? Y                                         |
|                                                                          |
|     DBEnvironment purged.                                                |
|     >>                                                                   |
____________________________________________________________________________

            



MPE/iX 5.0 Documentation