HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

SHOW 'DBEnvironmentName' VERSION 

Displays the current version number and startup parameters of the
DBEnvironment specified in the command. 

Scope 

SQLMigrate Only

SQLMigrate Syntax 

SHOW 'DBEnvironmentName' VERSION;

Parameters 

DBEnvironmentName     identifies the DBEnvironment to be previewed.

Example 

In the example below, the version of the DBEnvironment is F:

     SQLMIGRATE=> show 'PartsDBE' version; 

     VERSION          RELEASE
     F                HP36216-02A.F

                CURRENT STARTUP PARAMETERS:
                SINGLE USER MODE
                DUAL LOG,
                BUFFER = (50,50)
                TRANSACTION = 2
                MAXIMUM TIMEOUT = 3600 SECONDS,
                DEFAULT TIMEOUT = 30 SECONDS,
                RUN BLOCK = 37

                LOG DBEFILE DBELOG1 AND DBELOG2 WITH PAGES = 250,
                  NAME = 'DBEFile0'
                     AND 'DBEFile1';
     SQLMIGRATE=>

MPE/iX 5.5 Documentation