SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-31
ALTER TABLE Statement
name
is the name of the table or table partition to alter or move (or an equivalent
DEFINE). If name is a partition and you use clauses that apply to a entire table,
SQL interprets name as identifying all partitions of the table.
attribute-spec is:
{| { ALLOCATE int | DEALLOCATE } |}
{| { AUDIT | NO AUDIT } |}
{| { 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 g |}
reuse-spec is:
{ FIRST KEY { val | ( val [,val ] ... ) } }