HPlogo IMAGE/SQL Administration Guide: HP 3000 MPE/iX Computer Systems > Chapter 4 IMAGE/SQL Utility Commands

DISPLAY TURBODBS

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Glossary

 » Index

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.

The DISPLAY BASE command is synonymous with the DISPLAY TURBODBS command and has the same parameters and prerequisites.

Example

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



   >>
Feedback to webmaster