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:

  1. 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
     
  2. 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
    
    
     
  3. Press ENTER or END to exit.