Batch Processing › SARBCH Control Statements › DELETE

DELETE

The DELETE control statement deletes the following from the database:

• An archived SYSOUT
• The page indexes of a SYSOUT
• A user ID
• A logical view
• A Device
• A Filter

Syntax:

/DELETE ID=id
        RESOURCE=xxxxxxxx
        SECOND
        DISK
        GEN=nnnnn
        SEQ=nnnnn
        USER=xxxxxxxx
        VIEW=nnn
        INDEX
        FORCE
        DEV=sname
        FILT=fname

Where:

ID=id

Specifies the SYSOUT identifier on the SYSOUT or resource group or view that is to be deleted.

This value can be 1 to 32 characters. If this parameter is specified by itself or with the GEN and/or SEQ parameters, the respective archival SYSOUT group is permanently deleted from the database.

Note: If the id contains embedded blanks, commas, parentheses, equal signs, or quotes, it must be enclosed in quotes (single or double). Any quotes in Report-id must be entered as a pair of quotes because a non-paired quote ends the ID. For example, if the value is JIM’S REPORT, it must be entered as ‘JIM’’S REPORT’ or "JIM’S REPORT".

DISK

Specifies that the disk space occupied by the SYSOUT or resource group is to be deleted from the database.

If a report is on primary and secondary disk, the first DELETE DISK deletes the primary disk copy and the next DELETE DISK deletes the secondary disk copy.

If this is a resource group, DISK must be specified.

SECOND

Deletes the space on optical (secondary) disk allocated for a SYSOUT/report.

If a report is on primary and secondary disk, the DELETE SECOND deletes only the secondary disk copy.

GEN=nnnnn

Specifies the absolute or relative number of the generation of the SYSOUT group to be deleted.

If omitted, the most recently archived SYSOUT group for the ID is used. This parameter cannot be specified with the VIEW and USER parameters.

SEQ=nnnnn

Specifies the absolute or relative sequence number of the SYSOUT group to be deleted.

• If omitted, the most recently archived group for the ID and generation specified is deleted. This parameter cannot be specified with the VIEW and USER parameters.
• If GEN is omitted and SEQ is specified as a negative relative number, the SYSOUT relative to the most recently archived SYSOUT is processed.
• If GEN is omitted and SEQ is specified as a positive number, SEQ number is ignored and the most current SYSOUT is processed.

EX: SEQ=-1

The second most recently archived SYSOUT is processed regardless of its generation and sequence number.

EX: SEQ=-2

The third most recently archived SYSOUT is processed regardless of its generation and sequence number.

USER=
xxxxxxxx

Specifies the name of the USERID to be deleted from the database.

This parameter cannot be specified with the GEN and SEQ parameters.

VIEW=nnn

Specifies a number from 1 to 255 of the logical view to be deleted.

Specify an asterisk to delete all logical views for the specified SYSOUT group.

This parameter cannot be specified with the GEN and SEQ parameters.

INDEX

Deletes any created page indexes for the report on the disk database

The CA View online cross report indexing capability uses page indexes on disk. (The page index definitions still exist with the logical views for the report).

FORCE

Deletes a SYSOUT in OPEN status after prompting the user to verify that the job is no longer running.

Note: If the job is still processing the report, issuing FORCE could cause corruption of database data. Be sure that the job is not processing before issuing a DELETE FORCE for an OPEN report.

RESOURCE=

Specifies the name of an AFP RESOURCE rather than a Report ID.

Do not specify ID= when using the RESOURCE parameter.

This parameter allows an AFP resource to be deleted. This type of control statement is generated through SARTSLST.

DEV= sname

Specifies 1-12 character synonym name for device to be deleted. No other DELETE parameters are allowed.

FILT= fname

Specifies 1-8 character name for filter to be deleted. No other DELETE parameters are allowed.