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
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
.
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.
