Create the bpTableSelect Business Rules

1. Double-click bpTableSelect in the Projects window to open the Business Process Designer to the bpTableSelect Business Process.

2. Create the bpTableSelect FileClient.receive -> FileClient.write rule.

   1. Add a Business Rule to the link between FileClient.receive and FileClient.write and double-click the new Business Rule icon to open the Business Rule Designer.

   2. Create a string literal and enter Selecting record(s) from db_employee table via table select...as the String value.

   3. Map the Selecting record(s) from db_employee table via table select... output node of the string literal method box, to text under FileClient.write.input in the Input pane (right pane) of the Business Rule Designer.

3. Create the FileClient.write -> otdOracle.DB_EMPLOYEESelectAll rule.

   1. Add a Business Rule to the link between FileClient.write and otdOracle.DB_EMPLOYEESelectAll and double-click the new Business Rule icon to open the Business Rule Designer.

   2. Map text under FileClient.receive.Output in the Output pane of the Business Rule Designer, to the whereClause under otdOracle.DB_EMPLOYEESelectAll.Input in the Input pane.

4. Create the otdOracle.DB_EMPLOYEESelectAll -> otdInputDTD_DBemployees.marshal rule.

   1. Add a Business Rule to the link between otdOracle.DB_EMPLOYEESelectAll and otdInputDTD_DBemployees.marshal and double-click the new Business Rule icon to open the Business Rule Designer.

   2. From the Business Rule Designer String menu, select String.

      If String is not available from the String menu, click Settings on the String menu to open the Method Palette, and select String as an option from the String tab. This will add String to the String menu

   3. Map EMP_NO under otdOracle.Select_psPSSelectAll.Output -> output -> DB_EMPLOYEESelectAllTableResponseTypeList in the Output pane of the Business Rule Designer, to the object1? input node of the String method box.

   4. Map the return string output node of the String method box, to EmpNo under otdInputDTD_DBemployees.marshal.Input -> DBemployees -> X_sequence_A in the Input pane of the Business Rule Designer

   5. From the Business Rule Designer String menu, select String to add another String method box.

   6. Map RATE under otdOracle.Select_psPSSelectAll.Output -> output -> DB_EMPLOYEESelectAllTableResponseTypeList in the Output pane of the Business Rule Designer, to the object1? input node of the String method box.

   7. Map the return string output node of the String method box, to Rate under otdInputDTD_DBemployees.marshal.Input -> DBemployees -> X_sequence_A in the Input pane of the Business Rule Designer

   8. Map nodes under otdOracle.Select_psPSSelectAll.Output -> output -> DB_EMPLOYEESelectAllTableResponseTypeList in the Output pane of the Business Rule Designer, to the corresponding nodes under otdInputDTD_DBemployees.marshal.Input -> DBemployees -> X_sequence_A in the Input pane of the Business Rule Designer, as follows:

      • LAST_NAME -> Lastname

      • FIRST_NAME -> Firstname

      • LAST_UPDATE -> LastDate

5. Create the otdInputDTD_DBemployees.marshal -> FileClient.write rule.

   1. Add a Business Rule to the link between otdInputDTD_DBemployees.marshal and FileClient.write, and double-click the new Business Rule icon to open the Business Rule Designer.

   2. Map text under otdInputDTD_DBemployees.marshal.Output in the Output pane of the Business Rule Designer, to text under FileClient.write.Input1 in the Input pane.

6. Create the FileClient.write -> FileClient.write rule.

   1. Add a Business Rule to the link between FileClient.write element and FileClient.write, and double-click the new Business Rule icon to open the Business Rule Designer.

   2. Create a string literal and enter TableSelect Done...as the String value.

   3. Map the TableSelect Done... output node of the string literal method box, to text under FileClient.write.input2 in the Input pane (right pane) of the Business Rule Designer.