Data Manipulation Language Statements › #DELSCR—deletes scratch records › #DELSCR Parameters

#DELSCR Parameters

PLIST=

Specifies the location of the 3-fullword storage area in which the system will build the #DELSCR parameter list.

SYSPLIST

(Default); the symbolic name of the storage area in which the system will build the #DELSCR parameter list.

parameter-list-pointer

A register that points to the area or the symbolic name of the area in which the system will build the #DELSCR parameter list.

SAID=

Specifies the 1- to 8-character ID of the scratch area associated with the scratch record being deleted.

scratch-area-id-pointer

A register that points to a field containing the id, the symbolic name of a user-defined field containing the ID, or the ID literal enclosed in quotation marks. If the SAID parameter is not specified, a scratch area ID of 8 blanks is assumed.

LOC=

Specifies the scratch record to be deleted from the area associated with the specified scratch record id.

NEXT

(Default); deletes the next record. If currency has not been established, NEXT is equivalent to FIRST.

CURRENT

Deletes the current record, that record most recently referenced by another scratch function.

FIRST

Deletes the first record. (Records are always stored in ascending order by scratch record ID.)

LAST

Deletes the last record.

PRIOR

Deletes the prior record. If currency has not been established, PRIOR is equivalent to LAST.

ALL

Deletes all records.

(SRID,scratch-record-id)

Deletes the record identified by scratch-record-id. Scratch-record-id is a register that points to the 4-byte scratch record id, the symbolic name of a user-defined field containing the id, or an absolute expression of the id.

RTNSRID=(1)/

Specifies the location to which the system will return the scratch record ID of the last record deleted with a #DELSCR function.

return-scratch-record-id

A register or the symbolic name of a fullword user-defined field to which the system will return the scratch record ID of the last record deleted, the default is register 1.

COND=

Specifies whether this #DELSCR is conditional and under what conditions control should be returned to the issuing program, as follows.

NO

(Default); specifies that the request is not conditional.

ALL

Specifies that the request is conditional. Control is returned if the delete cannot be serviced for any of the reasons listed below.

condition

Specifies conditions under which control is returned to the issuing program. Multiple condition options must be enclosed in parentheses and separated by commas. Condition options are as follows:

• NAID The scratch area ID cannot be found.
• NRID The scratch record ID cannot be found.
• IOER An I/O error occurs while processing the deletion.
• INVP The parameter list built for the #DELSCR is invalid.

NAIDXIT=no-scratch-area-id-label

Specifies the symbolic name of the routine to which control should be returned if the #DELSCR request cannot be serviced because the scratch area ID cannot be found.

NRIDXIT=no-scratch-record-id-label

Specifies the symbolic name of the routine to which control should be returned if the #DELSCR request cannot be serviced because the scratch record ID cannot be found.

IOERXIT=i/o-error-label

Specifies the symbolic name of the routine to which control should be returned if the #DELSCR request cannot be serviced because of an I/O error while processing the #DELSCR request.

INVPXIT=invalid-parameter-list-label

Specifies the symbolic name of the routine to which control should be returned if the #DELSCR request cannot be serviced because of an invalid parameter list.

ERROR=error-label

Specifies the symbolic name of the routine to which control should be returned if a condition specified in the COND parameter occurs for which no other exit routine was coded.