6. QUEL and EQUEL Statements : Modify Statement—Change Table or Index Properties : Syntax
 
Syntax
[##modify tablename|indexname 
 to storage_structure  [unique]
 [on columnname [asc|desc]{, columnname [asc|desc]}]
 [with_clause]
A with_clause consists of the word with followed by a comma-separated list of any number of the following items:
allocation = n
extend = n
fillfactor=n  (isamhash, and btree only)
minpages=n  (hash only)
maxpages=n  (hash only)
leaffill=n  (btree only)
nonleaffill=n  (btree only)
newlocation=(location_name {, location_name})
oldlocation=(location_name {, location_name})
location=(location_name {location_name})
compression [= ([[no]key] [,[no]data])] | nocompression
[no]persistence
unique_scope = row | statement
To move a table:
[##modify tablename|indexname  to relocate
  with   oldlocation = (
locationname {, locationname}),
    newlocation = (
locationname {, locationname}),
To change locations for a table:
[##modify tablename|indexname   to reorganize 
  with location = (locationname {, locationname})
To delete all data in a table:
[##modify tablename|indexname  to truncated
To reorganize a btree table's index:
[##modify tablename|indexname  to merge
To add pages to a table:
[##modify tablename|indexname  to add_extend
  
[with extend = number_of_pages]
number_of_pages
Is 1 to 8,388,607