SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-23
Considerations for 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.
Table 5-1. Rules for copying SG Table data
Target column Source column Expected behavior
IDENTITY ALWAYS NO IDENTITY COLUMN FASTCOPY issues an
error. If the target col-
umn has IDENTITY
ALWAYS, the source
column must also have
IDENTITY ALWAYS for
the DEFAULT specifica-
tion type.
IDENTITY ALWAYS NO IDENTITY COLUMN FASTCOPY issues an
error. If the target col-
umn has IDENTITY
ALWAYS, the source
column must also have
IDENTITY ALWAYS for
the DEFAULT specifica-
tion type.
IDENTITY BY DEFAULT IDENTITY BY DEFAULT FASTCOPY uncondi-
tionally copies the base
table data. FASTCOPY
copies the
CURRENT_VALUE of the
SG TABLE only if the
SG Attributes and posi-
tion of the IDENTITY
column in the source
and target table match.
Otherwise, the
CURRENT_VALUE of the
target SG TABLE will not
be updated. To set the
CURRENT_VALUE of the
target SG TABLE, the
user can do ALTER
TABLE ALTER COL-
UMN RECALIBRATE .