MOVEFILE [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
MOVEFILE
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 [REV
BEG] Access Mode (Mapped) (opt): FileAccessMode [REV END]
Parameters
DBEnvironmentName is the name of the DBEnvironment with which the
file you are changing is associated.[REV BEG]
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.[REV END]
NewFileName is the new name of the file to be moved. The
[.NewGroupName] 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.[REV BEG]
* 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.
[REV END]
* 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.
MPE/iX 5.5 Documentation