8. SQL Statements : DELETE : Embedded Usage
Embedded Usage
In an embedded DELETE statement, specify the cursor name with a string constant or a host language variable.
If the DELETE statement does not delete any rows, the sqlcode variable in the SQLCA structure is set to 100. Otherwise, the sqlerrd(3) variable in the SQLCA structure contains the number of rows deleted.
There are two embedded versions of the DELETE statement: the first is similar to the interactive version of the statement, and the second is for use with cursors.