Delete secondary indices of NK-ISAM file
Component: | BS2000 |
Functional area: | File processing |
Domain: | FILE |
Privileges: | STD-PROCESSING |
Function
Using the DELETE-ALTERNATE-INDEX command, the user can delete secondary indices in a file.
If the command is terminated, the user will be unable to see the specified secondary indices (output produced by SHOW-INDEX-ATTRIBUTES), but there may still be blocks in the file which have not been released. These blocks will be released when a logical copy is made of the file (e.g. using the REPAIR-DISK-FILES command or the PERCON utility program).
Format
Operands
FILE-NAME = <filename 1..54>
The name of the file from which the specified secondary indices are to be deleted.
KEY-NAME = *ALL / list-poss(30): <name 1..8>
Identifies the secondary index/indices which are to be deleted.
Specifying *ALL will delete all the secondary indices in the file.
One list may specify the names of up to 30 secondary indices which are to be deleted.
Return codes
(SC2) | SC1 | Maincode | Meaning |
|---|---|---|---|
0 | CMD0001 | Command executed without errors | |
32 | DMS0A37 | Internal system error | |
32 | DMS0A3A | Inconsistent control block found | |
32 | DMS0A42 | Internal error on opening the file | |
32 | DMS0A43 | Internal error on closing the file | |
32 | DMS0A4F | RDTFT error | |
32 | DMS0A30 | Remote BS2000 system has a version < V10.0A | |
32 | DMS0A31 | Specified catalog ID does not exist | |
64 | DMS0A35 | Secondary index does not exist | |
64 | DMS0A46 | Not an NK-ISAM file | |
64 | DMS0A4E | SHARUPD = YES was specified | |
128 | DMS0A49 | Command interrupted | |
130 | DMS0A32 | Specified catalog ID not available | |
130 | DMS0A38 | Insufficient virtual memory | |
130 | DMS0A3C | Maximum number of secondary keys | |
130 | DMS0A3E | ISAM pool is overloaded |