Opening additional related table paths

Once a Related Table Edit session of dependent tables is initiated, you can open additional related paths, all originating from the same original driving table. You can open up to 16 paths or until your memory limit is reached.

Enter the REDIT command in any open window other than the last window, e.g. in window 2 OF 3, not 3 OF 3.

For example, you have opened a related dependent table PROJ, jumped back to the driving table EMP and entered the REDIT command (see the following figure).

Related Table Edit Display — EMP to PROJ Table

The Related Table List window (see the following figure) displays.

Related Table List Window

In the Related Table List window select one of the listed CHILD relationships or ADD a new relationship to open a new dependent path for the driving table EMP. Remember, you can’t select a PARENT as you already have more than one table open.

The above example selects the dependent table DEPT 2 and opens it for a related table edit session (see the following figure).

Related Table Edit — New Path EMP to DEPT

The display now shows the new dependent table DEPT (2) in the active window (2 OF 2) presenting only the dependent row(s) of the row displayed in the driving (parent) table. Notice that only the driving table includes which path is currently open (PATH 2 OF 2).

Now you have opened two parallel paths. The following figure shows the paths’ hierarchy.

Referential Integrity

Switching To Other Paths

File-AID for Db2 allows up to 16 paths to be open during a related edit session. However, only one table can be edited at a time. Use the PATH command to move to another path. When switching to another path, File-AID for Db2 makes the driving table window the active window (PATH 1 of 2). You can only edit data in an active window.

Use the JUMP command to move to other windows within the current path (see also Navigating Through Multiple Windows).

Blank or Next

Makes the next sequential path active. Wraps to the first path when the last path is reached.

n

Number - switches to the specified path number.

First

Switches to the first path (i.e. PATH 1 OF 9).

Last

Switches to the last path (i.e. PATH 9 OF 9).

Previous

Makes the previous sequential path active. Wraps to the last path when the first path is reached.

The following figure shows a Related Table Edit session. The active path is PATH 4 and the active window is window number 3. Enter PATH 2 to make path number 2 active.

PATH Command used to switch to Path Number 2

When you switch to a new path, you jump to window 1 of the path. It becomes highlighted and the other windows are protected.

Closing Individual Windows and Paths

Use the END command to close related editing windows and/or paths:

• END command issued in Windows greater than 3 (3 of 5) closes only this window and all its dependent windows.
• END command issued in Window 2 (2 of 5 in path 3, for example) closes the entire path.
• END command issued in Window 1 (1 of 5, for example) closes the entire related edit session.

Refer also to Saving Changes.