SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-110
Examples of POPULATE INDEX
resource unavailability, and missing a BEFORE or AFTER time window. Some
errors are retried automatically. Errors detected during the COMMIT phase are
retried based on the ONCOMMITERROR clause. Errors detected during the initial
and the data movement phases are retried individually and may include retry
counts.
•
Errors can occur if the source base table or target index cannot be accessed, or if
the load fails due to some resource problem or problem in the file system.
•
POPULATE INDEX does not work with SQL/MP alias names.
•
POPULATE INDEX need sufficient memory to copy the table and to create the
index respectively.
Examples of POPULATE INDEX
•
This example loads the specified index from the specified table:
POPULATE INDEX myindex ON mycat.myschema.mytable;
•
This example loads the specified index from the specified table, which uses the
default catalog and schema:
POPULATE INDEX index2 ON table2;
•
This is an example for online operation which loads the specified index from the
specified table, and uses the default catalog and schema:
POPULATE INDEX index2 ON table2 with-shared-access;
COMMIT BEFORE '2007-04-05 16:25:40'
ONCOMMITERROR COMMIT WORK AFTER '2007-04-05 25:19:00';