Chapter 5
Section 5.2
Using VSAM OTDs
Using Tables
VSAM eWay Adapter User’s Guide
50
Sun Microsystems, Inc.
5.2.1
Using the select Method
The
select
method returns result sets according to a group of predefined defaults.
However, you can change these defaults, if desired. In using the
select
method, you can
specify the following types of result sets:
TYPE_FORWARD_ONLY
TYPE_SCROLL_INSENSITIVE
TYPE_SCROLL_SENSITIVE
You can also specify the following result sets with a type of concurrency:
CONCUR_READ_ONLY
CONCUR_UPDATABLE
To perform an update, insert or delete operation, the type of the result set returned by
the
select
method must be CONCUR_UPDATABLE.
Instead of specifying the type of result set and concurrency in the
select
method, you
can also use the following methods:
setConcurrencytoUpdatable
setConcurrentlytoReadOnly
setScrollTypetoForwardOnly
setScrollTypetoScrollSensitive
setScrollTypetoInsensitive
Note:
Because of driver limitations, before you can do any modifications (insert, update, or
delete) to a table, the table must be under CICS control on the mainframe.
To call a method in the Collaboration Editor (Java)
1
Open the eGate Enterprise Designer’s Collaboration Editor (Java) for the desired
Collaboration Definition.
2
In the editor, navigate to the Business Rules Designer.
3
Right-click on the desired node (right or left pane) where you want to call the
method.
A pop-up
Method
selection menu appears, showing the methods available for the
node.
4
Select the desired method.
A
Method
box appears in the center pane of the Business Rules Designer. This box
represents the chosen method.
Note:
Using the
commit
method is optional for all update operations because the
Collaboration automatically commits the current transaction when it is done.
