SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Utilities

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001

5-15

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.

For a table with an IDENTITY column at the source, the target, or both, the

FASTCOPY utility copies the source base table data to the target base table, according

to existing FASCOPY logic for base tables. In addition, FASTCOPY updates the

CURRENT_VALUE in the target SG Table to match the copied base table data,

according to the rules described in Table 5-1

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.