Erasing an employee at a remote location

You can use the distributed organization sample application to erase information for employees at remote locations.

Procedure

To erase an employee at a remote location:

Enter the following values in the distributed organization sample application:

On the ACTION line, enter e for erase.
On the OBJECT line, enter em for employee.
On the SEARCH CRITERIA line, enter ei for employee number.
On the LOCATION line, enter your server location for the remote location.
On the DATA line, enter %, which displays a list of all the employees.

Figure 1. Starting the distributed organization application

                        DB2 ORGANIZATION APPLICATION
 ===>_


  ACTION .........:e       A  (ADD)              E  (ERASE)
                           D  (DISPLAY)          U  (UPDATE)

  OBJECT .........:em      DE (DEPARTMENT)       EM (EMPLOYEE)
                           DS (DEPT STRUCTURE)

  SEARCH CRITERIA :ei      DI (DEPARTMENT ID)    MN (MANAGER NAME)
                           DN (DEPARTMENT NAME)  EI (EMPLOYEE ID)
                           MI (MANAGER ID)       EN (EMPLOYEE NAME)

  LOCATION .......:your server location (Blank implies local location)

  DATA ...........:%

  PRESS: ENTER to process    END to exit

Press the ENTER key.

The panel below lists the employees that can be erased. Select the employee to be erased by inserting an S in the left margin by the employee ID.

Figure 2. Selecting an employee at a remote location

                        DB2 ORGANIZATION APPLICATION       ROW 1 OF 4
 ===>_

     ACTION: ERASE   AN EMPLOYEE                  LOCATION: SAN_JOSE

     TO SELECT FROM THE LIST PLACE AN S NEXT TO THE EMPLOYEE
     PRESS ENTER TO PROCESS OR END TO EXIT

     E/ID     EMPLOYEE NAME                       D/ID     DEPARTMENT NAME

 S   SJ0100   W  WALTERS                          F22      BRANCH OFFICE F22
     SJ0020   S  O'SHEA                           F22      BRANCH OFFICE F22
     SJ0030   D  COOPER                           F22      BRANCH OFFICE F22
     SJ0040   A  HAYES                            F22      BRANCH OFFICE F22
     SJ0050   L  ASHER                            F22      BRANCH OFFICE F22

Press the ENTER key.

The panel below displays the information relevant to the selected employee that is to be erased.

Figure 3. Employee to be erased

                        DB2 ORGANIZATION APPLICATION
 ===>_

                             ERASE   AN EMPLOYEE

   DEPARTMENT ID                     :  F22
              NAME                   :  BRANCH OFFICE F22
              MANAGER ID             :
              ADMIN DEP ID           :  E01
              LOCATION               :  SAN_JOSE

   EMPLOYEE   ID                     :  SJ0100
              FIRST NAME             :  W
              MIDDLE INITIAL         :
              LAST NAME              :  WALTERS
              WORK DEPT ID           :  F22


  PRESS: ENTER TO PROCESS    END TO EXIT

Press the ENTER key to erase the employee information.

A message appears on the panel stating the employee has been successfully erased. You can now erase another employee or press ENTER or END to exit.

Figure 4. Employee at a remote location erased

                        DB2 ORGANIZATION APPLICATION       ROW 1 OF 3
 ===>_
 DSN8003I   DSN8HC3-EMPLOYEE SUCCESSFULLY ERASED
     ACTION:   ERASE AN EMPLOYEE                  LOCATION: SAN_JOSE

     TO SELECT FROM THE LIST PLACE AN S NEXT TO THE EMPLOYEE
     PRESS ENTER TO PROCESS OR END TO EXIT

     E/ID     EMPLOYEE NAME                       D/ID     DEPARTMENT NAME

     SJ0020   S  O'SHEA                           F22      BRANCH OFFICE F22
     SJ0030   D  COOPER                           F22      BRANCH OFFICE F22
     SJ0050   L  ASHER                            F22      BRANCH OFFICE F22