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-24
Considerations for FASTCOPY
Equivalence Requirements

The target table and the source table must be sufficiently equivalent so that the
following command can be executed successfully:
insert into <target table> (*) select * from <source table>;
The two tables must have the same number of columns, and the columns with the
same ordinal position must have compatible data types. Also, either both tables
must have a SYSKEY column or none of the tables may have a SYSKEY column.
If the target table has indexes that are online, the clustering key for the target table
must be equivalent to the clustering key for the source table. The following details
must be identical between the clustering keys:

number of columns

ordinal position of each clustering key column within its table
IDENTITY BY DEFAULT IDENTITY ALWAYS 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.
IDENTITY column IDENTITY

BY DEFAULT

ALWAYS
FASTCOPY uncondi-
tionally copies the base
table data. Target SG
Table does not exist
since the target table
does not contain an
IDENTITY column.
Table 5-1. Rules for copying SG Table data