Accessing Auxiliary Storage: FILE › DB2 and SQL/DS Databases › FILE Functions for DB2 and SQL/DS Databases › Delete a Row

Delete a Row

Use the DELETE command to delete a row or several rows of data. Set conditions to determine when the deletion should be performed.

Example

To delete a department from a table, specify the following, and then press Enter:

DELETE FROM DSN8130.TEMPL WHERE WORKDEPT = 'D11' 

This command instructs FILE to delete from table DSN8130.TEMPL all rows in which the WORKDEPT is D11.

Before performing the deletion, FILE displays a second screen indicating how many rows will be deleted and asking you to confirm the deletion. Enter C to confirm the deletion or R to cancel it. If you enter C, FILE performs the deletion and informs you that the command was successfully executed.