HP 3000 Manuals

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