Specifies globals for a MUPIP EXTRACT operation. The format of the SELECT qualifier is:
-S[ELECT]= global-specification
By default, EXTRACT selects all globals, as if it had the qualifier -SELECT=*
The caret symbol (^) in the specification of the global name is optional.
The global-specification can be:
A parenthetical list, such as (a,B,C). In this case, MUPIP EXTRACT selects all globals except ^a, ^B, and ^C.
A global name, such as MEF. In this case, MUPIP EXTRACT selects only global ^MEF.
A range of global names, such as A7:B6. In this case, MUPIP EXTRACT selects all global names between ^A7 and ^B6, inclusive.
A list, such as A,B,C. In this case, MUPIP EXTRACT selects globals ^A, ^B, and ^C.
Global names with the same prefix, such as PIGEON*. In this case, EXTRACT selects all global names from ^PIGEON through ^PIGEONzzzzz.
![[Note]](images/note.jpg) | |
If the rules for selection are complex, it may be easier to construct an ad hoc Global Directory that maps the global variables to be extracted to the database file. This may not be permissible if the database file is part of a replicated instance. If this is the case, work with a backup of the database. |