Lecture
<preparable dynamic delete statement: positioned> :: = DELETE [FROM <table name>] WHERE CURRENT OF <cursor name>
Comment:
The main reason for the appearance of this and the following statements is that the combination of a cursor defined on a dynamically prepared sample operator and statically defined delete and modification operators on this cursor looks rather ridiculous. Therefore, dynamically prepared positional operators for deletion and insertion appeared in the standard. Naturally, they must be executed using the EXECUTE operator.
Comments
To leave a comment
Databases IBM System R - relational DBMS
Terms: Databases IBM System R - relational DBMS