Name the table or view from which you want to delete. The table or view must be described in the Datadictionary, but must not be a Datadictionary table or a read-only view.
You can specify a 1- to 18-byte correlation-name to be used within the search-condition to designate the table or view.
Introduces a condition that specifies what rows are to be deleted. You can omit the clause, give a search condition or name a cursor. If you omit the clause, all rows of the table or view are deleted.
Each column-name in the search condition must name a column of the table or view, and the table or view must not be referenced in the FROM clause of any subselect in the search condition. See the CA Datacom/DB SQL User Guide for the search-condition syntax diagram.
Each column-name in the search condition which is not in a subquery must name a column of the table or view being updated. In subqueries, the table or view being updated must not be named in any FROM clause.
If the search condition contains a subquery, the subquery can be thought of as being executed each time the search condition is applied to a row. The result of the subquery is used in applying the search condition. In actuality, the subquery is executed for each row only if it contains a correlated reference to a column of the table or view.
Not used in CA Dataquery.
|
Copyright © 2014 CA.
All rights reserved.
|
|