Network Card User Manual

Chapter 5 Section 5.2
Using VSAM OTDs Using Tables
VSAM eWay Adapter User’s Guide 51 Sun Microsystems, Inc.
5.2.2 Select Operations
To perform a select operation on a table
1 From the Collaboration Editor (Java), call the select method with the where clause
specified, if necessary.
The text from the Te xt node instructs the Business Process exactly which data needs
to be selected. For example, the content of the input text could be EMPID>100.
2 Loop through the result set using the next method.
3 For each loop, process the return record.
5.2.3 Insert Operations
To perform an insert operation on a table
1 From the Collaboration Editor (Java), call the insert method.
2 Set 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.
3 Activate the insertion by calling the insertRow method.
For multiple insert operations, you can use a while rule.
5.2.4 Update Operations
To perform an update operation on a table
1 From 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.
2 Call the next method.
3 Update the row by calling updateRow.
To update more than one column, you can repeat the Copy rule, as desired.
5.2.5 Delete 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.