HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

ATTACHFILE 

Attaches previously detached DBEFileSets and DBEFiles to the
DBEnvironment and makes them available for normal access.

Scope 

SQLUtil Only

SQLUtil Syntax 

>> ATTACHFILE  DBEnvironment Name:  DBEnvironmentName  Maintenance Word:

MaintenanceWord  Enter DBEFileSet name or Carriage Return to Finish:

DBEFileSetName  Enter DBEFileSet name or Carriage Return to Finish:

Enter DBEFile name or Carriage Return to Finish:  SystemFileName  Enter

DBEFile name or Carriage Return to Finish:    Do you wish to attach (y/n)

{y[es]}
{n[o] }
Parameters 

DBEnvironmentName       is the name of the DBEnvironment associated with
                        the DBEFileSets and DBEFiles to be attached.

MaintenanceWord         is the maintenance word.

DBEFileSetName          is the name of the DBEFileSet to be attached.
                        You may enter a list of DBEFileSets, one name per
                        line, with a carriage return to terminate the
                        list.  You may enter a carriage return by itself
                        if no DBEFileSets are to be attached.

SystemFileName          is the physical name of the DBEFile to be
                        attached.  You may enter a list of DBEFiles, one
                        name per line, with a null line to terminate the
                        list, or a carriage return by itself if no
                        DBEFiles are to be added.

Description 

   *   Attaching a DBEFileset makes all the DBEFiles in the DBEFileSet
       available for database access.

   *   Attaching explicitly named DBEFiles makes those specific files
       available for database access.

   *   You can determine whether a DBEFile is ATTACHED or DETACHED
       by looking at the column "ATTACHED" in the system views
       SYSTEM.DBEFILE or CATALOG.DBEFILE, or the "Static DBEFile" screen
       of SQLMON.

   *   Also refer to the SQLUtil DETACHFILE command.

Authorization 

You must be the DBECreator, have SM capability, or you must supply the
correct maintenance word to use this command.

Example 

     >> attachfile 
     DBEnvironment Name:  PartsDBE 
     Enter DBEFileset name or Carriage Return to Finish): WarehFS 
     Enter DBEFileset name or Carriage Return to Finish):
     Enter DBEFile name or Carriage Return to Finish: OrderDF1 
     Enter DBEFile name or Carriage Return to Finish:
     Do you wish to attach (y/n)? y 

     File(s) Attached.

MPE/iX 5.5 Documentation