SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-227
Considerations for FASTCOPY
according to existing FASTCOPY 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 2-7.
Table 2-7. 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-
ion type.