Sun Microsystems 5.1.3 Select Operations, Insert Operations, Update Operations, Delete Operations

Chapter 5	Section 5.2
Using VSAM OTDs	Using Tables

5.2.2Select Operations

To perform a select operation on a table

1From the Collaboration Editor (Java), call the select method with the where clause specified, if necessary.

The text from the Text node instructs the Business Process exactly which data needs to be selected. For example, the content of the input text could be EMPID>100.

2Loop through the result set using the next method.

3For each loop, process the return record.

5.2.3Insert Operations

To perform an insert operation on a table

1From the Collaboration Editor (Java), call the insert method.

2Set the fields of the table OTD where you want to do the insertion and insert the row using a Literal.

If you want to update multiple columns, you can repeat the Copy rule, as desired.

3Activate the insertion by calling the insertRow method. For multiple insert operations, you can use a while rule.

5.2.4Update Operations

To perform an update operation on a table

1From the Collaboration Editor (Java), call the update method with the where clause specified, if necessary.

In this case, a Literal is used instead of the text node. Either way of specifying the where clause is acceptable.

2Call the next method.

3Update the row by calling updateRow.

To update more than one column, you can repeat the Copy rule, as desired.

5.2.5Delete Operations

To perform a delete operation on a table

ƒFrom the Collaboration Editor (Java), call the delete method with the where clause specified, if necessary.

VSAM eWay Adapter User’s Guide 51 Sun Microsystems, Inc.