Iterating a view object using a secondary rowset iterator
There are times when you need to iterate through a view object rowset programmatically. In this recipe, we will see how to do this using a secondary rowset iterator. We will iterate over the Employees rowset and increase the employee's commission by a certain percentage for each employee that belongs to the Sales department.
Getting ready
This recipe was developed using the HRComponents workspace, which was created in the Overriding remove() to delete associated children entities recipe in Chapter 2, Dealing with Basics: Entity Objects. The HRComponents workspace requires a database connection to the HR schema.
How to do it...
1. Open the
Employeesview object definition and go to the Java page.2. Click on the Edit java options button (the pen icon) to open the Select Java Options dialog.
3. Click on the Generate View Object Class and Generate View Row Class checkboxes. Ensure that the Include accessors checkbox is also selected.
4....
