SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-11
FASTCOPY Utility
FASTCOPY Utility
Considerations for FASTCOPY
Examples of FASTCOPY
FASTCOPY is a syntax-based utility that can be executed through MXCI and from a
program using dynamic SQL. The RECOVER support is available for the FASTCOPY
utility. FASTCOPY is not available as an embedded SQL. For more information about
the FASTCOPY utility, see the SQL/MX Installation and Management Guide.
The two forms of FASTCOPY utility are:
•
FASTCOPY TABLE Command
•
FASTCOPY INDEX Command
FASTCOPY TABLE Command
The FASTCOPY TABLE command copies all the rows from one table to the existing
equivalent table. It requires select privileges on the source table, and insert, update,
and delete privileges on the target table.
source-table
is the ANSI name of the table where rows are copied from.
target-table
is the ANSI name of the table that is being copied into. The target table must exist
prior to the operation and must be equivalent with the source table. The existing
rows in the target table will be removed before the copying begins.
Note. The FASTCOPY utility is available only on systems running J06.08 and later J-series
RVUs and H06.19 and later H-series RVUs.
FASTCOPY TABLE source-table [TO] target-table
[ index-clause ]
index-clause is
INDEXES { EXPLICIT | IMPLICIT }