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

SQL/MX Utilities

HP NonStop SQL/MX Reference Manual—544517-008

5-108

POPULATE INDEX Utility

Syntax Description of POPULATE INDEX

Considerations for POPULATE INDEX

Examples of POPULATE INDEX

POPULATE INDEX is a syntax-based utility that can be executed through MXCI. The

POPULATE INDEX utility loads SQL/MX indexes.

Syntax Description of POPULATE INDEX

index-name

is an SQL identifier that specifies the simple name for the index. You cannot qualify

index-name with its schema names. Indexes have their own namespace within a

schema, so an index name might be the same as a table or constraint name.

However, no two indexes in a schema can have the same name.

table-name

is the name of the table-name for which to populate the index. See Database

Object Names on page 6-13.

WITH SHARED ACCESS

specifies that the operation is an online operation. If commit-options is omitted,

the effect is the same as specifying COMMIT WHEN READY ONCOMMITERROR

ROLLBACK WORK.

POPULATE INDEX index-name ON table-name [option]

index-name ::= name

table-name ::= [[catalog.]schema.]name

option ::= with-shared-access

with-shared-access ::= WITH SHARED ACCESS [commit-options]

commit-options ::=

{COMMIT [WORK] [ WHEN READY ] [on-error] }

{ [ { AFTER time } ] }

{ [ { BEFORE time } ] }

{ROLLBACK [WORK] }

on-error::= [ ONCOMMITERROR commit-options ]

time::= yyyy-mm-dd hr:min:sec[.precision]