Step 2—Confirming data to be deleted


File-AID/RDX displays the following figure after you specified the extract file to be used either from the Delete Reference List or the Extract File Specification screen.

Delete Confirmation

 File-AID/RDX -------------  Delete Confirmation  ------------------- SSID: DSN
 Command ===> NEXT                                             Scroll ===> PAGE

                                              Obj  Num rows/rec                 
 Object Name                                  Type to delete     Status         
 -------------------------------------------- ---- ------------ ----------------
 DSNLOCAT.FRSAMP.PART_TABLE                   DB2        10
 DSNLOCAT.FRSAMP.SUPPLIER_TABLE               DB2         0
 'TSOID01.FRSAMP.PARTTABL'                    File       10
 'TSOID01.FRSAMP.SUPPLIER'                    File        0
 'TSOID01.FRSAMP.CUSTOMER'                    File       11
 DSNLOCAT.FRSAMP.CUSTOMER_TABLE               DB2        11
 DSNLOCAT.FRSAMP.ORDER_TABLE                  DB2        15
 DSNLOCAT.FRSAMP.ORDER_LINE_TABLE             DB2        11
 DSNLOCAT.FRSAMP.CONTACT_TABLE                DB2         0
 'TSOID01.FRSAMP.CONTACTT'                    File        0
 ** End of List **



To specify the extract file:

In this field…

Do the following:

COMMAND

Type the NEXT primary command.

Press Enter

File-AID/RDX displays the Delete Processing Options screen.

Field Names and Descriptions

The following list describes all of the fields on this screen.

FIELD

DESCRIPTION

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 identifies the primary command available from this screen. For details on this command, see File-AID/Related Data XPERT Reference.

COMMAND

DESCRIPTION

NEXT

Displays the Delete Processing Options screen.

Line Commands

There are no line commands available from this screen.

 

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