16.1 Independent Operations

The Association Utility supports seven independent operations:

Table 16-1 Independent Operations

Operation

Description

Read-Write Functionality

1

List objects associated with a driver (default).

Read-only

2

List objects that have multiple associations to a driver.

Read-only

3

List objects that have invalid associations to a driver.

An association is invalid if:

  • It is malformed.

    For example, the association is missing the schema RDN, missing the table RDN, or the schema keyword is misspelled.

  • It contains database identifiers that do not map to identifiers in the target database.

    For example, an association includes a mapping to a table that does not exist.

  • It maps to no row or multiple rows.

    An association is broken if it doesn’t map to a row. Also, associations aren’t unique if they map to more than one row.

Read-only

4

List objects that need to be normalized.

A normalized association is valid, correctly ordered, and uses the correct case. Normal case is uppercase for case-insensitive databases and mixed case for case-sensitive databases.

Read-only

5

Normalize object associations listed during operation 4.

Write

6

List object associations to be modified.

Allows for global replacement of schema, table, and column names based on search criteria.

This operation requires two parameters (oldRDN and newRDN). See Editing Associations.

Read-only

7

Modify object associations listed during operation 6.

This operation requires two parameters (oldRDN and newRDN). See Editing Associations.

Write