SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Introduction

HP NonStop SQL/MX Reference Manual—523725-004

1-17

Concurrency

If you restore with PARTONLY (only one or more partitions are restored) or if you

restore the entire partition (that is, the partition did not exist in the target table before

restore), the redefinition time stamp of the table is updated.

If only data is restored (the partition existed in the target table before the restore), the

last open timestamp of partition data fork is updated, and the data modification

timestamp of the partition data fork is updated.

CREATE TRIGGER Yes, of the table on which the trigger is defined

CREATE VIEW No

DUP No

FIXUP Yes

GRANT No

IMPORT Yes, if using fast load technique

INFO No

MODIFY, all forms Yes

mxexportddl No

MXGNAMES No

POPULATE INDEX Yes

PURGEDATA Yes

RESTORE Yes**

REVOKE No

UPDATE STATISTICS No

VERIFY No

* Manual recompilation might be required.

** If you restore an entire table (including metadata), all timestamps are updated. The table needs to be dropped

and re-created.

Table 1-4. Operations Effect on Table Timestamps (page 2 of 2)

Alter Operation Timestamp Updated