Process Help

RENAME - rename a Datamine file

 

Process Name

Menu Path

Link to Command Table

RENAME

Data ribbon | Data Tools | Tables | Rename

Click here

 

Introduction

Renames a Datamine file in the project.

How to use

The new name must not exist in the project folder. If it does, an error message is produced, and the process is abandoned, unless the optional @DELETE parameter has been set to 1 and the user has write access to the output file.


Files, Fields and Parameters

Input Files

Name

Description

I/O Status

Required

Type

IN

File to be renamed.

Input

Yes

Table

Output Files

Name

I/O Status

Required

Type

Description

OUT

Output

Yes

Table

New file name (must not exist).


Notes

With work-file structure databases, when a file is renamed, a check is made to see if any database pages are still in existence with the new name chosen. This could happen if the file name had previously been used for a longer file. If this is the case, the message is produced:-

>>> DELETING ANY REMAINING PAGES OF ffffffff


Example

!RENAME     &IN(NAME),&OUT(NEWNAME)

>>> FILE name RENAMED OK, 99999 PAGES
>>> newname IS NEW NAME
>>> 99999999 RECORDS IN FILE newname <<<


Error and Warning Messages

Message

Description

Solution

>>> ERROR - FILE ffffffff ALREADY EXISTS <<<

>>> ERR 41 <<< ( fileno) IN RENAME

Rename attempt fails. Fatal; the process is exited.

 

 

 

 

>>> ERROR - FILE ffffffff ALREADY EXISTS AND CANNOT BE DELETED FIRST <<<

>>> ERR 42 <<< ( fileno) IN RENAME

Rename attempt fails as user does not have write access to the output file, which therefore cannot be deleted first. Fatal; the process is exited.