Sun Adapter for DB2 Tutorials

ProcedureCreate the bpTableSelect Business Process

  1. From the Projects window, right-click your new project and select New -> Business Process from the shortcut menu.

  2. Rename your new business process to bpTableSelect.

  3. Add the following activities to the bpTableSelect Business Process canvas.

    • FileClient.Receive (CAPS Components Library -> Adapters -> File -> FileClient)

    • FileClient.Write

    • FileClient.Write

    • FileClient.Write

    • DB_EMPLOYEESelectAll (prjDB2_BPEL -> otdALL -> otdDB2)

    • marshal (prjDB2_BPEL -> otdALL -> otdInputDTD_DB_employee)

  4. Connect the following activities: (See image below for details)

    • Start -> FileClient.receive

    • FileClient.receive -> FileClient.write

    • FileClient.write -> otdDB2.DB_EMPLOYEESelectAll

    • otdDB2.DB_EMPLOYEESelectAll -> otdInputDTD_DB_employee.marshal

    • otdInputDTD_DB_employee.marshal -> FileClient.write

    • FileClient.write -> FileClient.write

    • FileClient.write -> End

    Image shows the bpTableSelect Business Process from the
Business Process Designer.