Previous Topic: FormatNext Topic: Example 1: Deleting User IDs


Operand Explanations

The DELETE statement for users, profiles, and sessions has the following operands:

Operand

Explanation

TPX

Indicates that you want to delete the parameters. If you do not specify TPX or STX, Batch will delete regardless of type.

STX

Indicates that you want to delete the CA STX parameters. If you do not specify TPX or STX, Batch will delete regardless of type.

USER

Specifies that you want to delete a user.

PROFILE

Specifies that you want to delete a profile.

USERSESSION

Specifies that you want to delete a session from a user.

PROFILESESSION

Specifies that you want to delete a session from a profile.

ddname

Specifies the data definition name (DD name) of the input extract file that is used to indicate which users, profiles, user sessions, or profile sessions are to be deleted.