If you want your extraction criteria to be non-specific, you can use a masking character to mask the criteria value. The default masking character is a hyphen (-). You can mask any number of characters of the value (from one to the number of characters in the value). For example, the following EXTRACT statement produces the output file named SALEDEPT, containing the user records for all users whose user IDs begin with SALES, regardless of the last three characters:
EXTRACT GIVING(SALEDEPT) USER AND NO SESSIONS (UIDXNAME(SALES---))
The value of the masking character is stored in a variable named MASKCHAR. You can use a SET statement to change the value of MASKCHAR so that your masking character does not conflict with actual values in the records. For example, if you want to make the masking character an exclamation point (!), use the following SET statement:
SET MASKCHAR '!'
|
Copyright © 2013 CA.
All rights reserved.
|
|