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-18

FASTCOPY TABLE Command

The FASTCOPY TABLE command copies all the rows from one table to the existing

equivalent 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.

index-clause

specifies how FASTCOPY TABLE will treat indexes. The index-clause has

these values:

The default is INDEXES IMPLICIT.

FASTCOPY INDEX Command

The FASTCOPY INDEX command copies all rows from one index to the existing

equivalent index.

source-index

is the ANSI name of the index that is being copied from.

FASTCOPY TABLE source-table [TO] target-table

[ index-clause ]

index-clause is

INDEXES { EXPLICIT | IMPLICIT }

EXPLICIT Indexes on the target table will be explicitly copied. For each

matching pair of source and target indexes, the FASTCOPY

INDEX Command can be used to explicitly perform the copy

concurrently with the copy of the table, if required. Each

target index must have a matching source index.

IMPLICIT All indexes on the target table are maintained automatically

as a part of the FASTCOPY utility.

FASTCOPY INDEX source-index [TO] target-index