Utility Messages (20000 through 23099)
HP NonStop SQL/MX Messages Manual—640324-001
18-129
SQL 21071
Where target-table is the three-part ANSI name of the target table for a
FASTCOPY command.
Cause. The target table for an initial FASTCOPY command is non-empty; is the
subject table for a DELETE trigger that is enabled.
Effect. The operation fails; involved objects are left unchanged.
Recovery. Disable DELETE triggers on the target table, retry the FASTCOPY
command, and then enable the triggers again.
SQL 21072
Where target-table is the three-part ANSI name of the target table for a
FASTCOPY command.
Cause. The target table for an initial FASTCOPY command has a system defined
SYSKEY column, and is the subject table for one or more triggers. A FASTCOPY
command cannot operate on such a table.
Effect. The operation fails; involved objects are left unchanged.
Recovery. Drop all triggers that have the target table as subject table, retry the
FASTCOPY command, and then re-create the triggers. If necessary, execute queries
that will perform the trigger actions.
SQL 21073
Cause. The target table for a FASTCOPY command has an ANSI name part that is
longer than 122 characters. This is not supported by FASTCOPY.
Effect. The operation fails; involved objects are left unchanged.
Recovery. None.
21071 target-table has DELETE triggers enabled.
21072 target-table has a SYSKEY column and is the subject
table for a trigger.
21073 FASTCOPY does not support target tables with names
longer than 122 characters.
To Next Page