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-17
FASTCOPY Utility
The two forms of FASTCOPY utility are:
•
FASTCOPY TABLE Command
•
FASTCOPY INDEX Command
IDENTITY BY DEFAULT IDENTITY ALWAYS FASTCOPY unconditionally
copies the base table data.
FASTCOPY copies the
CURRENT_VALUE of the
SG_TABLE only if the SG
Attributes and position of the
IDENTITY column in the
source and target table
match. Otherwise, the
CURRENT_VALUE of the tar-
get SG Table will not be
updated. To set the
CURRENT_VALUE of the tar-
get SG Table, the user can
do ALTER TABLE ALTER
COLUMN RECALIBRATE.
IDENTITY BY DEFAULT NO IDENTITY COLUMN FASTCOPY unconditionally
copies the base table data.
The CURRENT_VALUE of the
target SG Table will not be
updated. The target SG
TABLE will have default val-
ues. To set the
CURRENT_VALUE of the tar-
get SG_TABLE, the user
can do ALTER TABLE
ALTER COLUMN RECALI-
BRATE.
IDENTITY column IDENTITY
•
BY DEFAULT
•
ALWAYS
FASTCOPY unconditionally
copies the base table data.
Target SG Table does not
exist since the target table
does not contain an IDEN-
TITY column.
Table 5-1. Rules for copying SG Table data
Target column Source column Expected behavior