HPlogo ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX Computer Systems > Appendix F SQLUtil

SHOWACCESS

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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.

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.

Authorization

Any user may execute this command.

Example

   >> 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


Feedback to webmaster