Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

CANCEL-STATEMENT

Cancels a DML statement

Scope of validity

DBH administration

Function

The CANCEL-STATEMENT statement cancels the processing of a statement that manipulates a user's data.

The following must be observed:

  • The user must be active in the DBH.

  • If a rollback of the transaction has already been registered for the user, the DBH accepts the administration statement but does not execute it.

  • A CANCEL-STATEMENT statement cannot cancel a previous CANCEL-STATEMENT statement.

CANCEL-STATEMENT

USER = <user-identification>

Operands

USER = <user-identification>

Identifies the user to which the CANCEL-STATEMENT statement applies. The identification must be unique. You must specify all the relevant partial qualifications (see section “Syntax for the identification of users”).


Administration command in ISP format and at the CALL DML interface

The CANCEL administration command corresponds to the CANCEL-STATEMENT administration statement here.

CANCEL,user-identification