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

MOVEFILE

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Moves the DBECon file or any DBEFile across devices.

Scope

SQLUtil Only

SQLUtil Syntax

>> MOVEFILE DBEnvironment Name: DBEnvironmentName Current File Name: CurrentFileName New File Name: NewFileName [.NewGroupName ] Current Device: CurrentDeviceNumber New Device (opt): NewDeviceNumber Access Mode (Mapped) (opt): FileAccessMode

Parameters

DBEnvironmentName

is the name of the DBEnvironment with which the file you are changing is associated.

CurrentFileName

is the name of the file to be moved. Only DBEFiles can be moved with the MOVEFILE command. DBECon files cannot be moved with the MOVEFILE command.

NewFileName .[NewGroupName]

is the new name of the file to be moved. The file can be moved to a new group by specifying the optional NewGroupName preceded by a period (.).

CurrentDeviceNumber

is the device number of the device on which the file currently resides. This value is displayed by MOVEFILE.

NewDeviceNumber

is the device number of the device to which the file should be moved. Use the MPE/iX SHOWDEV command to display a list of available devices. If nothing is entered at the prompt, the file is not moved.

FileAccessMode

is MAPPED to specify that the DBEFile is accessed as an MPE/iX mapped file. The default is to leave the access mode of the file unchanged. Pseudo-mapped is no longer supported.

Description

  • The MOVEFILE command first prompts for the current name of the file to be moved. It then prompts for the new name for the file and allows you to specify an optional group name if you wish to place the file in a new group. MOVEFILE then displays the current device number of the device on which the specified file resides, then it prompts for a new device number. The file is moved to the device with the number the user specifies. You can specify the old device number if you do not want to change devices. You can use the MPE/iX LISTF,3 command for the specified file to display both the current device class name and the current device number. If you press Return instead of entering a new device number, the file is not moved.

  • The MOVEFILE command can be used to change a file's group but not the account, which always remains the same as the account of the DBECon file.

  • The MOVEFILE command can be used to change a DBEFile's access mode to mapped (the default mode is mapped). If you press Return in response to the prompt for access mode, the access mode is left unchanged.

NOTE: Pseudo-mapped access is no longer supported. If any files are currently pseudo-mapped, use the MOVEFILE command to convert them to MAPPED.
  • You can display the access modes for the DBEFiles in a DBEnvironment by using the SHOWACCESS command.

  • To change the access mode without physically moving the DBEFile, press Return in response to the New Device prompt, then enter the access mode. Now you can convert the DBEFiles to Mapped mode. If they already in mapped mode, press Return to move the files.

  • To retain the current access mode, press Return in response to the prompt for Access Mode.

  • You cannot convert the DBECon file to a pseudo-mapped file.

  • The MOVEFILE command can only be executed when the DBEnvironment is not in use.

Authorization

You must either be the DBECreator or have SM capability to use this command.

Example

   >> movefile

   DBEnvironment Name:  PartsDBE.SomeGrp.SomeAcct

   Current File Name: PARTIDX1

   New File Name: PARTIDX1.OtherGroup

   Current Device:  DISC

   New Device (opt):  2

   Access Mode (Mapped)(opt): Return



   File moved.
Feedback to webmaster