HP 3000 Manuals

DISPLAY TURBODBS [ HP IMAGE/SQL Administration Guide ] MPE/iX 5.0 Documentation


HP IMAGE/SQL Administration Guide

DISPLAY TURBODBS 

Displays all TurboIMAGE/XL databases currently attached to a
DBEnvironment and, optionally, their associated mapped tables.

Syntax 

DI[SPLAY] TURBODB[S] [TABLES] [FOR DBEnvironment [,MAINT=DBE_MaintWord]]

Parameters 

TABLES            is an option that displays all mapped tables in each
                  TurboIMAGE/XL database attached to the DBEnvironment.
                  If this parameter is omitted, no table information is
                  displayed.

DBEnvironment     is the name of the DBEnvironment whose attached
                  TurboIMAGE/XL databases you want to see.  If this
                  parameter is omitted, the DBEnvironment must have been
                  previously specified with the SET SQLDBE command or
                  else an error message is issued.

DBE_MaintWord     is the maintenance word for the DBEnvironment.  This
                  parameter can be omitted if you are the DBECreator.

Prerequisites 

   *   SET SQLDBE issued or DBEnvironment (and maintenance word, if not
       DBECreator) specified as part of the command.

Description 

Use the DISPLAY TURBODBS command to display information about all of the
TurboIMAGE/XL databases attached to a DBEnvironment.  Optionally, all
tables in each TurboIMAGE/XL database are also listed.

Example 
[REV BEG]

In the following example, the databases currently attached to the
PARTSDBE.SERED.ATC DBEnvironment are listed.
________________________________________________________
|                                                      |
|     >>DISPLAY TURBODBS FOR PARTSDBE.SERED.ATC        |
|                                                      |
|     DBEnvironment    : PARTSDBE.SERED.ATC            |
|                                                      |
|     BASE FILE               OWNER          BASE TYPE |
|     ---------               -----          --------- |
|                                                      |
|     SALES1.SERED.ATC        SALES1         TurboIMAGE|
|     SALES2.SERED.ATC        SALES2         TurboIMAGE|
|     DB1.SERED.ATC           SERED          TurboIMAGE|
|     DB2.SERED.ATC           DB2            TurboIMAGE|
|                                                      |
|     Total Databases : 4[REV END]                     |
|     >>                                               |
________________________________________________________

            



MPE/iX 5.0 Documentation