3. Statements : OpenROAD SQL Statements : Delete Statement : Parameters—Delete Statement
 
Share this page                  
Parameters—Delete Statement
This statement has the following parameters:
tablename
Specifies the name of the table from which the row is deleted. It is used in both versions of the delete statement. This is a dynamic name.
corrname
Specifies the correlation name of the table. It is used in only the non-cursor version.
searchcondition
Specifies a logical expression of conditions that must be satisfied by all rows selected. You can use simple variables in a search condition wherever you can use a constant. Alternatively, you can place the entire search condition in a single varchar variable.
cursor_variable
Specifies the reference variable that points to the CursorObject for which the statement is issued. It is used only in the cursor version.