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. The DBEnvironment may be either an absolute pathname or a pathname relative to your current working directory.
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, be a superuser, 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.