Extracting Data › EXTRACT Statement Syntax › Operands

Operands

The EXTRACT statement has the following operands:

ddname

Specifies the data definition name (DD name) of the output extract file. The data extracted from the administration database is written to this file.

The DCB information is controlled by the program and should not be specified. The maximum record size that can be extracted is equal to that of the ADMIN2 file; use this value in conjunction with the expected record count to be extracted and your media type to determine space requirements. The final disposition of the data set is under JCL control.

USER

Specify USER to extract user records.

PROFILE

Specify PROFILE to extract profile records.

MAILMESSAGE

Specify MAILMESSAGE to extract mail locators.

USERLIST

Specify USERLIST to extract user lists.

ACT

Specify ACT to extract application definition records.

AND ALL SESSIONS

Indictes that all of the session records associated with each user or profile record are extracted, regardless of the extraction criteria that you specify. Sessions associated with a profile are extracted even if previously deleted from the user. (Use the UENTDEL variable to determine if the session has been deleted.)

AND MATCHING SESSIONS

Indicates that only sessions which match extraction criteria containing a session value are extracted. If you specify AND MATCHING SESSIONS and the extraction criteria does not contain a session variable, no sessions are extracted.

AND NO SESSIONS

None of the session records associated with each user or profile record is extracted, even if the extraction criteria contain a session variable.

variable

The name of any valid user, profile, or session variable. These variables represent the fields on the online administration panels. You can specify as many variables as you like, but a record will be extracted only if it matches all of the criteria variables. For a list of the variables that you can use and the corresponding online administration fields, see the appendix Variables.

The variable can also be one of the variables listed in the following table. These variables allow you to extract users, sessions, or profiles according to what component they are associated with. These variables can have a value of Y or N.

VUSR$TPX(value)

Selects the user if user has signon authority.

WUSR$TPX(value)

Selects the profiles.

VSES$TPX(value)

Selects the user sessions.

WSES$TPX(value)

Selects the profile sessions.

value

This is the value of the variable that is used as a criterion for extracting records. You can specify as many values as you like. Records are extracted if the specified variable contains one of the specified values. For a detailed discussion of specifying variables and values, see Specify Extraction Criteria.