SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
5-119
Examples of POPULATE INDEX
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';