REMOVE Verb - Delete Key from Keyed File
Syntax
REMOVE (channelno,KEY=string{,ERR=lineref}{,DOM=lineref})
Description
For BBj-specific information, see REMOVE Verb - BBj.
The REMOVE statement deletes a key from a keyed file.
|
Parameter |
Description |
|---|---|
|
channelno |
Valid channel number. |
|
KEY=string |
Key to be removed. |
|
ERR=lineref |
Branch to be taken if an error occurs during execution. |
|
DOM=lineref |
Error branch to use if the key is not found. |
The KEY=, ERR=, and DOM= clauses can appear in any order.
PRO/5 fills the associated data record with nulls ($00$) and leaves the file pointer at the key that alphabetically follows the removed key, or at end-of-file. If the desired key does not exist, PRO/5 leaves the file pointer where it was and reports a missing key error, !ERROR=11. A failed REMOVE releases any record locks. REMOVE may be performed on keyed files only.
All C-ISAM files created by INFORMIX4GL and ISQL are created without a primary key. The REMOVE verb will not remove a record that has no primary key from a file. Also, for C-ISAM files, a locked record is released after any successful REMOVE operation, even if the record removed was not the locked record.
Examples
1000 REMOVE(1,KEY="TEST KEY",ERR=9500)