Specifying masks

You can use masks when you generate SQL to reverse engineer Db2® objects, clone a work statement list (WSL), or migrate objects, data, or catalog statistics.

About this task

Specifying masks is a substep of one of the following procedures:

Procedure

To specify masks:

Ensure that one of the following panels is opened:
- Generate SQL from DB2 catalog (ADB2GENB) panel
- Clone Work Statement List (ADB2W1Q) panel
The panel that you use depends on which function you are using.
In the Use Masking field, specify Yes and press Enter:
On the Specify Masks (ADB2GENM) panel, specify the mask to use by completing one of the following set of steps:

To specify a mask that is defined in a data set:
1. Specify the name of the data set that contains the masks that you want to use. If the specified data set does not exist, it is created.
  The mask data set must adhere to TSO naming conventions and be one of the following types:
  - A fixed-block sequential data set (RECFM=Fx)
  - A member of a partitioned data set with a record length of 80 (LRECL=80)
2. In the Edit Mask field, specify whether you want to edit the mask data set.
3. Press Enter.
  
  If you specified that you wanted to edit the mask, an ISPF edit panel opens. On this panel, you can make changes to the mask definitions. When you are done making changes, issue the SAVE command and exit out of the ISPF editor.
To specify a mask that is defined in a table in the Change Management database:
1. Specify the owner and the name of the mask table entry in the Owner and Name fields.
  (The Mask Table Entry fields where you can specify an owner and name are displayed only if Change Management is enabled on your system.)
2. Leave the Mask DSN field blank.
  (If you specify both a data set and a mask table entry, a data set is used.)
3. In the Edit Mask field, specify whether you want to edit the mask definitions.
4. Press Enter.
  
  If you specify a mask table entry that does not exist, that table entry is created for you in the Change Management database.
  
  If you specified that you wanted to edit the mask, the Mask Lines (ADB2C2L) panel opens. On this panel, you can make changes to the mask definitions. For more information about how change the definitions, see Creating masks in the Change Management repository
```
DB2 Admin ----------------------- Specify Mask ----------------------------
Option ===>                                                                   
                                                                              
                                                                              
Mask Table Entry:                                                             
  Owner . .           >            (? to look up)                             
  Name  . .                     >  (? to look up)                             
Data Set:                                                                     
  Mask DSN  . .                                              
Options:                                                                      
  Edit Mask . .      (Yes/No) 
```

What to do next

Finish the remaining steps of one of the following the procedures for which you wanted a mask: