Delete confirmation

The Delete Confirmation screen shown in the following figure is displayed after you specified the extract file to be used for the delete request.

Delete Confirmation

 File-AID/RDX -------------  Delete Data Summary  ------------------------------
 Command ===>                                                   Scroll ===> PAGE

 Extract File: TSOID01.FRSAMP.EXTRACT
 SSID: DSN  Location:

                                              Obj  Num rows/rec                 
 Object Name                                  Type to delete     Status         
 -------------------------------------------- ---- ------------ ----------------
 LOCATION.FRSAMP.PART_TABLE                   DB2        28                     
 LOCATION.FRSAMP.SUPPLIER_TABLE               DB2        32                     
 LOCATION.FRSAMP.CUSTOMER_TABLE               DB2        15                     
 LOCATION.FRSAMP.ORDER_TABLE                  DB2        33                     
 LOCATION.FRSAMP.ORDER_LINE_TABLE             DB2        49                     
 LOCATION.FRSAMP.CONTACT_TABLE                DB2        18                     
 'TSOID01.FRSAMP.CONTACTT'                    File       18
 'TSOID01.FRSAMP.ORDERLIN'                    File       49
 'TSOID01.FRSAMP.PARTTABL'                    File       28
 'TSOID01.FRSAMP.ORDERTAB'                    File       33
 'TSOID01.FRSAMP.SUPPLIER'                    File       32
 ** End of List **

Use this screen to view information about the data to be deleted. The fields on this screen are display-only—you cannot modify any values on this screen. Use the NEXT command to proceed.

In addition to the screen title and COMMAND field, the heading lines on this screen contain the following field:

SSID

Displays the ID of the Db2 subsystem in which the tables and views that contain rows to be deleted exist.

The body of this screen consists of the following fields:

Object Name

Displays the fully qualified name of the object from which to delete. If it is a Db2 object it includes the location and creator ID of the table. MVS object names are fully qualified and enclosed in single quotes (’).

OBj Type

The object type is indicated in the next column


    • Db2
    • File (MVS KSDS)

Num rows/rec to delete

Displays the number of rows or records that were extracted from each object when the extract file was generated. A value of 0 in this column indicates that no rows or records were extracted from the object and none will be deleted.

Important

If your extract file was generated by a release of File-AID/RDX earlier than release 1.2, File-AID/RDX will display N/A for each object in this column.

Status

If File-AID/RDX cannot find an object from which rows are to be deleted, it displays the message Object not found.

Primary Commands

The following File-AID/RDX-specific primary command is valid on this screen:

NEXT

The NEXT command invokes the Delete Processing Options screen.

Related topics

Delete-Request-file-member-list

Delete-processing-options

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*