ARRAY DELETE
This command deletes the current row from the array.
Command | Parameters |
|---|---|
ARRAY | ARY DELETE | Name |
The following table describes the parameters.
Parameter | Function | Notes |
|---|---|---|
Name | Name of the array as established during array creation | Enter a 1- to 31-alphanumeric characters name |
Condition codes are listed in the following table.
Value | Description |
|---|---|
0 | Command was executed successfully. |
4 | Array is empty. |
8 | Array is not found. |
12 | Array is not in UPDATE access. |
16 | Syntax error occurred. |
Example
This EXEC deletes all rows in an array beginning with those rows where variable VOL is greater than or equal to the string BAB.
"IMFEXEC ARRAY CONNECT DASDSTATS"
"IMFEXEC ARRAY FIND DASDSTATS CRITERIA('VOL,,,>=, ''BAB''') ROW(1)"
do while imfcc=0
"IMFEXEC ARRAY DELETE DASDSTATS"
"IMFEXEC ARRAY FIND DASDSTATS CRITERIA('VOL,,,>=, ''BAB''') ROW(1)"
end
"IMFEXEC ARRAY FIND DASDSTATS CRITERIA('VOL,,,>=, ''BAB''') ROW(1)"
do while imfcc=0
"IMFEXEC ARRAY DELETE DASDSTATS"
"IMFEXEC ARRAY FIND DASDSTATS CRITERIA('VOL,,,>=, ''BAB''') ROW(1)"
end
CLIST examples:
IMFEXEC ARRAY FIND DASDSTATS CRITERIA('VOL,,,>=,''BAB''') ROW(1)
DO WHILE &IMFCC=0
IMFEXEC ARRAY DELETE DASDSTATS
IMFEXEC ARRAY FIND DASDSTATS
CRITERIA('VOL,,,>=,''BAB''') ROW(1)
END
DO WHILE &IMFCC=0
IMFEXEC ARRAY DELETE DASDSTATS
IMFEXEC ARRAY FIND DASDSTATS
CRITERIA('VOL,,,>=,''BAB''') ROW(1)
END
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*