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'