Validate Worksheet Format

Some cross reference workbooks have a validate worksheet. It identifies the worksheets in the configuration data workbook that should be validated and the order in which the data is validated. The worksheet also contains other attributes for the validate operation.

Table 1 shows the validate worksheet columns that are present for each row in the worksheet. The user should only modify the validate column. Consult IBM® Support before modifying any of the other columns.
Table 1. Cross Reference Validate Worksheet Columns
Column Description
Validate Sheet Name The name of the worksheet in the configuration data workbook that contains the actual configuration data to be validated.
Validate Indicates if the data should be validated.
The valid values are:
Y
The configuration data associated with this cross reference row is validated.
N
The configuration data associated with this cross reference row is not validated.
Map Sheet Name The name of the map workbook worksheet to use with the worksheet specified in the validate sheet name column.