FDRARCH DELETE Statement

DELETE statement syntax

DELETE statement

The DELETE statement is used to mark records within the Archive Control File for deletion. The statement may appear more than once in the control statement input if you need to delete records based on several sets of criteria. The actual deletion does not take place until the next reorganization (REORG) of the control file; up to that time you may use the RESET statement to turn off the DELETE indicator.

The DELETE parameters are saved for later processing. Please review Archive-Maintenance-Utility-FDRARCH to understand when the Archive Control File is scanned and the DELETE indicator set in the selected records.

Many of the operands of DELETE will accept comparison operators in addition to a simple equal (=). The operators are:

In most cases, you may also specify an operand more than once, such as ADAYS>5,ADAYS<20 to select a range of values.

A record must meet all of the selection criteria specified to be marked for deletion.

DELETE statement operands

Specifies the date of the ARCHIVE run of the records to be selected. Only data sets archived on this date are marked. See the note on operators above to specify comparisons and ranges.

The date is specified as a Julian date (year plus day number) that may be in the form “yyyyddd” (for example, 2020123) or “yyddd” (for example, 20123). If the 2-digit year is used “yyddd”, year numbers less than 70 are considered to be in the 21st century, for example, 20345=2020.345. For readability, a period may be inserted between the year and day (for example, 2020.123).

For data sets that were archived with RECALL=NO (no Auto-Recall), including FDRAPPL Application Backups, the control file contains a time of day as well as a date. In this case, you can select by date and time, for example, ADATE=20123/140522 or ADATE=2020123/140522.

nnnnn

Specifies that records that were archived “nnnnn” days ago (from 0 to 32000) are to be selected. See the note on operators above to specify comparisons and ranges.

DSGROUP=

Specifies one or more data set name prefixes (up to 44 characters in length) to be selected. Multiple prefixes may be specified in parentheses, separated by commas. Only Archive Control File entries whose name begins with one of the prefixes are marked. See the note on operators above to specify comparisons and ranges. The XDSN= operand, described below, offers a much more flexible way of selecting data sets

DSNAME=

Specifies one or more data set names (up to 44 characters in length) to be selected. Multiple names may be specified in parentheses, separated by commas. See the note on operators above to specify comparisons and ranges.

EXPDATE=

Specifies the expiration date of the ARCHIVE records to be selected. If both a COPY1 and COPY2 backup exist for the data set, the higher of the two expirations is tested. See the note on operators above to specify comparisons and ranges.

The date is specified as a Julian date (year plus day number) that may be in the form “yyyyddd” (for example, 2020123) or “yyddd” (for example, 20123). If the 2-digit year is used “yyddd”, year numbers less than 70 are considered to be in the 21st century, for example, 20345=2020.345. For readability, a period may be inserted between the year and day (for example, 2020.123).

EXPDAYS=

Specifies that records whose expiration date is within “nnnnn” days of today's date are to be selected. The value can be from 1 to 32000 and can be positive (for example, EXPDAYS=5 or EXPDAYS=+5 means 5 days from today) or negative (for example, EXPDAYS=-5 means 5 days ago). It will never consider data sets whose expiration date is 99.000, 99.365 or 99.366 to be expired. See the note on operators above to specify comparisons and ranges.

Used in conjunction with IFNOTCAT. It requests archived entries are to be marked for removal from the Archive Control File if they are no longer cataloged, even if they were not archived with the recall option.

Default: The archive entries must be marked for recall to be eligible for IFNOTCAT processing.

Specifies that entries that were archived with the recall option are to be marked for removal from the Archive Control File if they are no longer cataloged or if the catalog no longer indicates they are eligible for auto recall processing.

Default: The catalog status of the entries is not checked.

SIMULATE

Makes the desired modifications in the selected records.

SIMULATE

Causes the statement to operate in simulation mode, so that you can verify that the parameters you have specified will have the correct results. It will report on what records it would modify if it was not in simulation mode, but will not update the control file.

Default: REAL.

TAPEFILE=

nnnnn

Specifies a file sequence number (1 to 65534) of the archive tape data set that contains the entry that is to be selected. Ignored unless TAPEVOL= is also specified.

TAPEVOL=

Specifies a volume serial number of the archive tape data set that contains the entry that is to selected. The volume serial number is matched against both the COPY1 and COPY2 volume serial number lists.

Multiple volume serials can be specified by enclosing the list in parentheses and separate them by commas. However, the complete list of volume serials is compared to every record in the Archive Control File. If a given archive run used multiple output tapes, you may have some data sets in a backup file entirely contained on one tape, some entirely on the second tape, and some that are in a file that crossed between the two tapes. You may need multiple DELETE statements with, for example:

TAPEVOL=000001

TAPEVOL=(000001,000002)

TAPEVOL=000002

to select all the entries on those tapes.

VOLUME=

Specifies the volume serial number of the DASD from which the data sets to be selected were archived. Only those records having a matching originating volume serial number is selected. Multiple serials may be specified by enclosing them in parentheses separated by commas. Volume serial prefixes can be specified by following the prefix with an asterisk, for example, VOL=TSO*. See the note on operators above to specify comparisons and ranges.

VOLGROUP=

Specifies the prefix of the DASD volume serial number from which the data set was archived. If the volume serial number test is successful, the data set is eligible for selection. This is not an exact match operand (that is, compare length is from 1 to 6 inclusive.) Only those DASD volume serial numbers that start with the prefix specified are considered.

XDSNAME=

Specifies one or more data set name masks, as defined in Generic Data Set Name Selection in Generic-Data-Set-Name-Selection. The mask allows for flexible specification for the data set names to be selected. Multiple masks may be specified in parentheses, separated by commas. Only Archive Control File entries whose name matches one of the masks are selected. See the note on operators above; XDSN accepts only equal (=) or not equal (Ø=) comparisons. For example: