2—delete row

You can use the Delete row option to remove an existing row from an open table. When you select the Delete row option, perform these tasks on the Tables panel:

Specify the name of a table in the Table Name field. If the table is not open, specify NOWRITE or WRITE in the "Open tables" field.
Specify a row number or a search operand list to identify a row.

When you press Enter, a panel is displayed (Figure 1) to allow you to confirm the delete request.

Figure 1. Confirm table row delete panel (ISPYTPCD)

 ┌──────────────────────────────── Dialog Test ────────────────────────────────┐
 │   Menu  Utilities  View  Help                                               │
 │ ─ ┌─────────────── Confirm Table Row Delete ────────────────┐ ────────────  │
 │ I │ ISPYTPCD                                                │               │
 │   │                                                         │  More:     +  │
 │ 1 │ Table name  : ISPKEYS                                   │ ructure       │
 │ 2 │                                                         │ atus          │
 │   │ Row number  : 1                                         │               │
 │ T │                                                         │ r WRITE or    │
 │   │                                                         │  no TBOPEN)   │
 │ R │          Press ENTER key to confirm delete.             │               │
 │ B │                                                         │               │
 │   │          Press END key to cancel delete.                │ lank)         │
 │   │ Command ===>                                            │               │
 │   │  F1=Help       F2=Split      F3=Exit       F7=Backward  │               │
 │   │  F8=Forward    F9=Swap      F12=Cancel                  │               │
 │   └─────────────────────────────────────────────────────────┘               │
 │                                                                             │
 │                                                                             │
 │ DBCS column specification:                                                  │
 │ Option ===> 2                                                               │
 │  F1=Help        F2=Split       F3=Exit        F4=Expand      F5=Rfind       │
 │  F6=Resize      F7=Backward    F8=Forward     F9=Swap       F10=Actions     │
 └─────────────────────────────────────────────────────────────────────────────┘

The fields on the panel are:

Table name: Name of an open table
Row number: Number of the row to be deleted.

Press Enter to delete the row, or enter the END or CANCEL command to cancel the deletion.