Specifying ignore relationship options

Use the Access Definition Editor to specify whether to exclude rows from processing if a relationship has a specific value.

You can ignore relationships with values equal to null, blank, zero length, any numeric value you choose, or any combination of these options.

  1. Expand the folder in the Directory Explorer that contains the access definition, expand the Access Definitions node, and double-click the access definition. The Access Definition Editor opens.
  2. Select the Relationships tab.
  3. Select the relationship.
  4. Select the Ignore Relationship Options tab.
  5. Select a Combine the column options with option, which determines whether or not criteria are combined. Select And to ignore a relationship if all relationship columns match the criteria. Select Or to ignore a relationship if any columns match the criteria.

  6. Specify the following criteria:
    Ignore Null
    Ignore null values. This option is valid for all data types.
    Ignore Blank
    Ignore blank values. This option is valid for fixed and variable length character columns.
    Ignore Zero Length
    Ignore zero length values. This option is valid for variable length character columns.
    Ignore Numeric Value
    Ignore a numeric value. Enter the value in the Value to Ignore column. This option is valid for INTEGER type numeric columns.
  7. Save the access definition.


Feedback