Other Data Manipulation Statements
Unlike retrieve, other EQUEL database access statements do not have an inherent loop structure. The following example shows the use of the EQUEL append, replace, and delete statements.
begin program
## ename character_string(21)
## salary float
## eno integer
ename = "smith"
salary = 15000
## ingres "personnel"
## range of e is employee
## append to employee (empname = ename,
###salary = salary)
salary = 17500
## replace e (#salary = salary)
## where e.empname = ename
## delete e where e.#salary = salary
## exit
end program
As with the retrieve statement, the non-cursor versions of the delete, append, and replace statements can be formulated as repeated queries.