Table Procedure Examples, Design, and Use › Choose Unique Key Fields › SELECT and Searched UPDATE and DELETE Operations

SELECT and Searched UPDATE and DELETE Operations

SELECT processing or searched UPDATE or DELETE operations do not require a unique key to locate a row. Searched UPDATEs and DELETEs use database currencies based on search criteria in the Where clause, as described in "Defining and Using Table Procedures" in the CA IDMS SQL Reference. The CA IDMS Online Control Facility or Batch Control Facility lets you update multiple rows if the query result returns more than one row. However, not all query tools allow you to update multiple rows.