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-289
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.
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
Modify operations on a table, index, or sequence generator updates the redefinition
timestamp of the table, index, or sequence generator. Hence, all the existing executor
opens are invalidated. The next time the executor attempts to open the file, a similarity
check is performed. If it fails, programs are recompiled.
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.