HP 3000 Manuals

SHOWACCESS [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation


ALLBASE/SQL Database Administration Guide

SHOWACCESS 

The SHOWACCESS command displays the file access mode for all the DBEFiles
in a DBEnvironment.

Scope 

SQLUtil Only

SQLUtil Syntax 

>> SHOWACCESS  DBEnvironment Name:  DBEnvironmentName  Maintenance Word:

MaintenanceWord 

Parameters 

DBEnvironmentName       is the name of a DBEnvironment containing
                        DBEFiles whose access mode you wish to display.

MaintenanceWord         is the maintenance word.

Description 

   *   Use this command to display the access mode of the DBEFiles in a
       DBEnvironment with the MOVEFILE command.[REV BEG]

       _________________________________________________________________ 

       NOTE  Pseudo-mapped files are no longer supported.  If any files
             are currently pseudo-mapped, use the SQLUtil MOVEFILE
             command to convert them to mapped files.

       _________________________________________________________________ 
       [REV END]

Authorization 

Any user may execute this command.

Example 
[REV BEG]

     >> SHOWACCESS 
     DBEnvironment Name: PARTSDBE.SOMEGRP.SOMEACCT 
     Maintenance Word: Return 

     PARTSF0     mapped
     PURCHDF1    mapped
     PURCHXF1    mapped
     WAREHDF1    mapped
     WAREHXF1    mapped
     ORDERDF1    mapped
     ORDERXF1    mapped
     RECDF1      mapped
[REV END]



MPE/iX 5.5 Documentation