Displaying department structure at the local location
You can use the distributed organization sample application to display department structure at the local location.
Procedure
To display a department structure:
- Enter the following values in the distributed organization
sample application:
- On the ACTION line, enter D for display.
- On the OBJECT line, enter DS for department structure.
- On the SEARCH CRITERIA line, enter DI for department number.
- On the LOCATION line, leave blank, indicating local location.
- On the DATA line, enter A00 for department number.
Figure 1. Starting the distributed organization application DB2 ORGANIZATION APPLICATION ===>_ ACTION .........:d A (ADD) E (ERASE) D (DISPLAY) U (UPDATE) OBJECT .........:ds DE (DEPARTMENT) EM (EMPLOYEE) DS (DEPT STRUCTURE) SEARCH CRITERIA :di DI (DEPARTMENT ID) MN (MANAGER NAME) DN (DEPARTMENT NAME) EI (EMPLOYEE ID) MI (MANAGER ID) EN (EMPLOYEE NAME) LOCATION .......: (Blank implies local location) DATA ...........:a00 PRESS: ENTER to process END to exit
- Press the ENTER key. The panel below shows the structure of the department requested.
Figure 2. Displaying department structure DB2 ORGANIZATION APPLICATION ROW 1 of 5 ===>_ PRESS: ENTER TO PROCESS END TO EXIT DEPARTMENT STRUCTURE FOR: ----- DEPARTMENT ID AND NAME------ ----- MANAGER ID AND NAME------------- A00 SPIFFY COMPUTER SERVICE DIV. 000010 CHRISTINE I HAAS SUBDEPARTMENTS: A00 SPIFFY COMPUTER SERVICE DIV. 000010 CHRISTINE I HAAS B01 PLANNING 000020 MICHAEL L THOMPSON C01 INFORMATION CENTER 000030 SALLY A KWAN D01 DEVELOPMENT CENTER E01 SUPPORT SERVICES 000050 JOHN B GEYER
- Press ENTER or END to exit.