Step 3—Specifying Delete Processing Options
File-AID/RDX displays the following figure when you complete the Delete Confirmation screen and enter the NEXT command.
Delete Processing Options
Command ===> NEXT
Extract Dataset Name: FRSAMP.EXTMENU
Discard Processing Options:
Maximum Rows to Discard ===> * (* for no maximum)
Save Discarded Rows ===> NO (Yes or No)
Dataset for Discarded Rows ===>
Specify Processing Options for DB2 Objects:
Commit Every Nth Row ===> 50 (1-500)
Save a Request ===> Y (Y or N)
Use the NEXT command to continue
To specify processing options: | |
|---|---|
In this field… | Do the following: |
Maximum Rows to Discard | Type * |
Save Discarded Rows | Type NO |
Commit Every Nth Row | Type 50 |
Save a Request | Type Y |
Command | Type the NEXT primary command |
Press Enter. | File-AID/RDX displays the delete JCL in an ISPF/PDF EDIT screen. |
Field Names and Descriptions
The following list describes all of the fields on this screen.
FIELD | DESCRIPTION |
|---|---|
Extract File Name | Displays the name of the extract file on which you base the delete. |
Maximum Rows to Discard | Indicate the maximum number of errors encountered before processing stops. |
Save Discarded Rows | Indicate whether rows that could not be deleted should be saved. |
File for Discarded Rows | Specify the name of the file to which discarded rows will be saved. |
Specify Processing Options Area: | Specify the Db2 processing options to be used when deleting Db2 data. This section only displays when there are Db2 objects in the extract file. |
Commit Every Nth Row | Indicate the number of rows File-AID/RDX should insert or update before it performs a Db2 COMMIT. |
Save a Request | Specify whether or not to save the delete request to a request file. When Yes, File-AID/RDX presents the Save Delete Request panel where you identify the delete request file to save your request to. |
Primary Commands
The following identifies the primary command available from this screen.
COMMAND | DESCRIPTION |
|---|---|
NEXT | Displays the ISPF/PDF EDIT - Delete JCL screen or the Save Delete Request screen if you specify Y in the Save a Request field. |
Line Commands
There are no line commands available from this screen.