Displays the currently executing Oracle Rdb software version
    number and the version of Oracle Rdb required to access the
    specified database.

1  –  Description

    This command is useful when you have multiple versions of Oracle
    Rdb running on your system and perhaps multiple databases. If
    the currently executing version of Oracle Rdb is not the version
    required to access the database, change the current version of
    Oracle Rdb to the required version. See Example 3 in the Examples
    help entry under this command.

2  –  Format

  (B)0   RMU/Show Version [root-file-spec]

     Command Qualifier                 x Default
                                       x
     /Output[=file-name]               x /Output = SYS$OUTPUT

3  –  Parameters

3.1  –  root-file-spec

    A database root file specification. The default file extension
    is .rdb. If you do not specify a database root file, RMU Show
    Version displays only the version of Oracle Rdb under which
    Oracle RMU is currently running.

4  –  Command Qualifiers

4.1  –  Output

    Output[=file-name]

    Specifies the name of the file where output will be sent. The
    default is SYS$OUTPUT. The default output file extension is .lis,
    if you specify a file name.

5  –  Usage Notes

    o  You do not need any special privileges to use the RMU Show
       Version command.

    o  When the RMU Show Version command executes, it sets the
       following two DCL local symbols:

       -  RMU$RDB_VERSION

          Set to the currently executing version of Oracle Rdb

       -  RMU$DATABASE_VERSION

          Set to the version of Oracle Rdb required to access the
          specified database

       If you want to set the DCL symbols, RMU$RDB_VERSION and
       RMU$DATABASE_VERSION, only and do not want the RMU Show
       Version output, specify the null device as the file name with
       the Output qualifier. For example:

       $ RMU/SHOW VERSION MF_PERSONNEL /OUTPUT=NL:

       $ SHOW SYMBOL RMU$RDB_VERSION
         RMU$RDB_VERSION = "7.0"

       $ SHOW SYMBOL RMU$DATABASE_VERSION
         RMU$DATABASE_VERSION = "6.1"

6  –  Examples

    Example 1

    The following command displays the current version of Oracle Rdb
    software:

    $ RMU/SHOW VERSION
    Executing RMU for Oracle Rdb V7.0-64

    Example 2

    The following command displays the current version of Oracle Rdb
    software and the version of Oracle Rdb required to access the mf_
    personnel database:

    $ RMU/SHOW VERSION MF_PERSONNEL
    Executing RMU for Oracle Rdb V7.0-64
    Database DISK:[MYDIR]MF_PERSONNEL.RDB;1 requires version 7.0

    Example 3

    The following example demonstrates how you might use the RMU Show
    Version command to determine how to access a database that is
    incompatible with the currently executing version of Oracle Rdb:

    $ ! The RMU Show Version command tells you that the currently
    $ ! executing version of Oracle Rdb is Version 7.0, but
    $ ! that mf_personnel requires Version 6.1.
    $
    $ RMU/SHOW VERSION MF_PERSONNEL
    Executing RMU for Oracle Rdb V7.0-00
    Database DISK:[MYDIR]MF_PERSONNEL.RDB;1 requires version 6.1
    $
    $ ! If you ignore this information and attempt to attach to the
    $ ! database, you receive an error.
    $
    $ SQL
    SQL> ATTACH 'FILENAME MF_PERSONNEL';
    %SQL-F-ERRATTDEC, Error attaching to database MF_PERSONNEL
    -RDB-F-WRONG_ODS, the on-disk structure of database filename is
     not supported by version of facility being used
    -RDMS-F-ROOTMAJVER, database format 61.0 is not compatible
     with software version 70.0
    SQL> EXIT;
    $ ! Assign the currently executing version of Oracle Rdb to
    $ ! RMU$PREV_VERSION
    $ !
    $ rmu$prev_version := 'rmu$rdb_version'
    $ !
    $ ! Use the RDB$SETVER.COM command file to set the version of
    $ ! Oracle Rdb to the version required by mf_personnel.
    $ ! (For more information on the RDB$SETVER.COM command
    $ ! file, see the Oracle Rdb Installation and Configuration Guide.)
    $ !
    $ @SYS$LIBRARY:RDB$SETVER 'RMU$DATABASE_VERSION'
    $ !
    $ ! Re-execute the RMU Show Version command to confirm that you have
    $ ! the version of Oracle Rdb set correctly.
    $ !
    $ RMU/SHOW VERSION MF_PERSONNEL
    Executing RMU for Oracle Rdb V6.1-00
    Database DISK:[MYDIR]MF_PERSONNEL.RDB;1 requires version 6.1
    $ ! Invoke SQL and attach to the mf_personnel database.
    $ !
    $ SQL
    SQL>ATTACH 'FILENAME MF_PERSONNEL';
    SQL> SHOW TABLES
    User tables in database with filename MF_PERSONNEL
         CANDIDATES
         COLLEGES
         CURRENT_INFO                    A view.
         CURRENT_JOB                     A view.
         CURRENT_SALARY                  A view.
         DEGREES
         DEPARTMENTS
         EMPLOYEES
         JOBS
         JOB_HISTORY
         RESUMES
         SALARY_HISTORY
         WORK_STATUS
    SQL> EXIT
    $ !
    $ !Reset the executing version of Oracle Rdb to the original setting.
    $ !
    $ @SYS$LIBRARY:RDB$SETVER 'RMU$PREV_VERSION'