SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-288
Renaming Guardian Location of Partitions of Tables,
Indexes or Sequence Generators
Renaming Guardian Location of Partitions of Tables, Indexes or
Sequence Generators
You can use MODIFY to rename the Guardian filename part at one or more locations
of an existing table, index or a sequence generator. However, you cannot rename the
system, volume, or subvolume part of the Guardian location.
[[catalog.]schema.]object
is the ANSI name of the object. The object can either be a table, index or
sequence generator depending on the keyword TABLE, INDEX or SEQUENCE. If
you do not specify the schema and the catalog name, the default catalog and
schema names are used.
rename-spec
specifies how source files will be renamed to the corresponding target files. The
operation uses rename-spec to rename one or more source files to the
corresponding target file names.
The MODIFY form to rename the Guardian location of partitions of a table, or
index:
MODIFY { TABLE | INDEX | SEQUENCE } [[catalog.]schema.]object
RENAME [ WHERE ] LOCATION
{ rename-spec | ( rename-spec [, rename-spec ] ... ) }
[OUTFILE oss-file [CLEAR]]
rename-spec is:
{ simple-rename-spec
| pattern-map-spec }
simple-rename-spec is: location TO file-name-part
pattern-map-spec is: pattern MAP NAMES TO target-map }
location is:
The Guardian file name of a source location to rename.
file-name-part is:
The Guardian file name part to rename the source location
to.
pattern is:
Standard Guardian file name pattern.
target-map is:
an 8-character specification of how matching source file
names will be renamed. It consists of letters, digits, and
(?) characters.