Displaying department information at the local location

You can use the distributed organization sample application to display department structure at the local location.

Procedure

To display department information:

Enter the following values in the distributed organization sample application:

On the ACTION line, enter D for display.
On the OBJECT line, enter DE for department.
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 .........:de      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 department information that was requested.

Figure 2. Displaying department information

                        DB2 ORGANIZATION APPLICATION
 ===>_

                             DISPLAY A DEPARTMENT

   DEPARTMENT ID                     :  A00
              NAME                   :  SPIFFY COMPUTER SERVICE DIV.
              MANAGER ID             :  000010
              ADMIN DEP ID           :  A00
              LOCATION               :

   MANAGER    ID                     :  000010
              FIRST NAME             :  CHRISTINE
              MIDDLE INITIAL         :  I
              LAST NAME              :  HAAS
              WORK DEPT ID           :  A00


  PRESS: ENTER TO PROCESS    END TO EXIT

Press ENTER or END to exit.