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-129
Examples of POPULATE INDEX
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';