SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)
SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-95
Considerations for MODIFY
location
specifies the Guardian file name of an individual location to be renamed. If not fully
qualified Guardian defaults apply.
file-name-part
is the Guardian file name part of the renamed location.
Pattern
is a standard Guardian file name pattern which is specified to select those
partitions from the table that need to be renamed. If the Guardian file name pattern
is not fully qualified, the Guardian defaults apply.
target-map
is used to construct Guardian file name parts for the target location names. Each
target map position corresponds to the same position in the source file name.
Letters and digits will appear unchanged in the target file name. However, question
mark characters (?) will be substituted with the characters at the same position in
the source file name. A mapping specification has eight characters, each of which
can be:
A digit in the range 0 through 9 or a letter in the range A through Z. The target
file name will contain these digits or letters in the same position as mentioned
in the target-map.
A question mark (?), the target file name will contain the characters from the
source file name at the corresponding positions as (?) in the target-map.
For more details, see examples of MODIFY on page 5-101.
oss-file
is the OSS path name of a log file that records the outcome of the operation. This
is an optional file.
Considerations for MODIFY
You can run MODIFY as either an offline or online operation. You can perform
online operations while the partition is being used by another application. You can
perform offline operations only on partitions that are not being used by other
Note. An error in target mapping can produce file names that already exist or a pattern that
does not select any partitions.
Note. If the log file already exists, the output is appended to the existing content. If the CLEAR
option is used, the output overwrites the existing content.
Note. RENAME changes the redefinition timestamp of the affected table or index.