You must specify the INVALID KEY phrase for files for which an applicable EXCEPTION/ERROR procedure is not specified.
After processing of a DELETE statement for which a NOT INVALID KEY phrase has been specified, control transfers to imperative-statement-2.
For files in sequential access mode, the INVALID KEY and NOT INVALID KEY phrases must not be specified; however, an EXCEPTION/ERROR procedure may be specified.
For files in random or dynamic access mode, the results of DELETE statement execution depend on whether the file organization is indexed or relative:
For files in random or dynamic access mode, both the INVALID KEY phrase and the EXCEPTION/ERROR procedure may be omitted.
Click here for further information about the INVALID KEY condition.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.