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-16
FASTCOPY Utility
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 column has
IDENTITY ALWAYS, the
source column must also
have IDENTITY ALWAYS for
the DEFAULT specification
type.
IDENTITY ALWAYS IDENTITY ALWAYS If SG Attributes and the posi-
tion of the IDENTITY col-
umn matches for the source
and the target, FASTCOPY
copies the base table as well
as the CURRENT_VALUE
value of the SG TABLE. Oth-
erwise, FASTCOPY issues
an error.
IDENTITY BY DEFAULT IDENTITY BY DEFAULT 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 RECALI-
BRATE .