SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-14
ALTER INDEX Statement
security-spec is:
{| { CLEARONPURGE | NO CLEARONPURGE } |}
{| NOPURGEUNTIL date |}
{| SECURE "rwep" |}
attribute-spec is:
{| { ALLOCATE int | DEALLOCATE } |}
{| { AUDITCOMPRESS | NO AUDITCOMPRESS } |}
{| { BUFFERED | NO BUFFERED } |}
{| LOCKLENGTH int |}
{| MAXEXTENTS int |}
{| RESETBROKEN |}
{| { SERIALWRITES | NO SERIALWRITES } |}
{| TABLECODE int |}
{| { VERIFIEDWRITES | NO VERIFIEDWRITES } |}
move-spec is:
{| CATALOG catalog-name |}
{| PHYSVOL volume-name |}
{| EXTENT { size1 | ( size1 [, size2 ] ) } |}
{| MAXEXTENTS int |}
{| { FORMAT 1 | FORMAT 2 } |}
{| DSLACK percent |}
{| ISLACK percent |}
{| SLACK percent |}
wsa-spec is:
{| NAME operation-name |}
{| |}
{| REPORT [ TO collector | ON | OFF ] |}
{| |}
{| { COMMIT [ WORK ] [commit-options] } |}
{| { ROLLBACK [ WORK ] } |}
add-spec is:
{| FIRST KEY { val | ( val [,val ] ... ) } |}
{| WITH DATA MOVEMENT |}
{| CATALOG catalog-name |}
{| PHYSVOL volume-name |}
{| EXTENT { size1 | ( size1 [, size2 ] ) } |}
{| MAXEXTENTS int ] |}
{| { FORMAT 1 | FORMAT 2 } |}