Sun Microsystems SUN SEEBEYOND eWAY, Руководство пользователя, Страница: 55 / 115

Chapter 6 Section 6.2
Using VSAM Operations VSAM eWay Database Operations (JCD)
VSAM eWay Adapter User’s Guide 55 Sun Microsytems, Inc.
6.2
VSAM eWay Database Operations (JCD)
The same database operations are also used in the JCD, but appear as methods to call
from the Collaboration.
Tables and Views are manipulated through OTDs. Methods to call include:
ƒ
insert()
ƒ
insertRow()
ƒ
update( String sWhere )
ƒ
updateRow()
ƒ
delete( String sWhere )
ƒ
deleteRow()
ƒ
select( String where )
Note: Refer to the Javadoc for a full description of methods included in the VSAM eWay.
6.2.1
The Table
A table OTD represents a database table. It consists of fields and methods. Fields
correspond to the columns of a table while methods are the operations that you can
apply to the OTD. This allows you to perform query, update, insert, and delete SQL
operations in a table. The ability to update via a resultset is called “Updatable
Resultset”, which is a feature supported by this eWay.
By default, the Table OTD has UpdatableConcurrency and ScrollTypeForwardOnly.
Normally you do not have to change the default setting.
The type of result returned by the select() method can be specified using:
ƒ
SetConcurrencytoUpdatable
ƒ
SetConcurrencytoReadOnly
ƒ
SetScrollTypetoForwardOnly
SelectOne where() clause (optional) Returns the first row that fits
the condition of the where()
clause.
Insert definition of new item to be
inserted Returns status.
Update where() clause Returns status.
Delete where() clause Returns status.
Table 10 VSAM Operations (Continued)
eInsight Operation Activity Input Activity Output