Previous Topic: DECLARE STATEMENTNext Topic: Searched DELETE

SQL Statements › DELETE

DELETE

This SQL statement can be executed in the following ways:

Through the CA Datacom Datadictionary Interactive SQL Service Facility (interactive)

In an application program prepared using a CA Datacom/DB SQL Preprocessor (embedded)

By using CA Dataquery (SQL & Batch Modes)

DELETE (positioned)

 

YES

 

DELETE (searched)

YES

YES

YES

Note: YES indicates a valid execution method for this statement. To learn about using SQL keywords in CA Dataquery, see the CA Dataquery User Guide. For information about the access rights required to execute this statement, see the CA Datacom/DB Database and System Administration Guide.

The DELETE statement deletes rows from a table or view. Deleting a row from a view deletes the row from the table that the view is based on.

You must specify ISOLEVEL=C (isolation level C) in the Preprocessor options when using the DELETE statement

Note: When the NOMAINT option of the CA Datacom/DB Utility (DBUTLTY) ACCESS function is in force, a DELETE statement receives a CA Datacom/DB return code 94(87), where 87 is a decimal internal return code (hex 57) that tells you no maintenance statements are allowed while NOMAINT is in force.

Following is the syntax diagram for a DELETE statement:

►►─┬─ searched DELETE ───┬────────────────────────────────────────────────────►◄
   └─ positioned DELETE ─┘

Note: The positioned DELETE is not used by CA Dataquery.