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

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

321

322

323

324

325

326

327

328

329

330

SQL/MX Statements

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005

2-228

Considerations for FASTCOPY

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.

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 2-7. Rules for copying SG Table data