Previous Topic: Manage ErrorsNext Topic: Specify Multiple Values


Specify Multiple Variables

If you specify more than one variable in the extraction criteria, all records that match all of the criteria are extracted. For example, the following statement extracts a user record and puts it in an extract file named PRIVUSRS if the user has a command class of A and an update class of A:

EXTRACT GIVING(PRIVUSRS) USER AND NO SESSIONS (UIDXPRSV(A) UIDXUPDC(A))