HPlogo IMAGE/SQL Administration Guide: HP 3000 MPE/iX Computer Systems > Appendix C IMAGE/SQL and Database Utilities

SQLUtil

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Glossary

 » Index

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.

   >>
Feedback to webmaster