HP 3000 Manuals HP 3000 Manuals
DELETE Statement (Executable) The DELETE statement deletes a record from an indexed sequential access (ISAM) file.----------------------------------------------------------------------------------------------- | | | | | Item | Description/Default | Restrictions | | | | | ----------------------------------------------------------------------------------------------- | | | | | unit | Expression specifying unit | Must be a nonnegative integer. | | | number of a connected file. | | | | | | ----------------------------------------------------------------------------------------------- | | | | | variable_name | Error code return. | Must be an integer type. | | array_element | | | | scalar_record_field_name | | | | | | ----------------------------------------------------------------------------------------------- | | | | | label | Statement label. | Must be an executable statement | | | | in the same program unit. | | | | | ----------------------------------------------------------------------------------------------- Semantics In the most recent operation on the file, the record to be deleted must have been read with a READ statement. If the most recent operation was not a read of a record, a run-time error occurs. If the prefix UNIT= is omitted and the unit specifier is present, unit must be the first item in the list. If the ERR specifier is present and an error occurs during execution of the DELETE statement, control transfers to the specified statement rather than aborting the program. If the IOSTAT specifier is present and an error occurs, the error code is returned in the IOSTAT variable and the program is not aborted. Refer to Appendix A for IOSTAT error codes. Examples Notes -------------------------------------------------------------------------------------- READ (10,key='111-22-333',KEYID=0) employee_rec Deletes a record with the key DELETE (10,ERR=555, IOSTAT=I) value 111-22-333.
![[]](../../pic3k/M012118/FFN193c50.gif)