Sun Microsystems 5.1.3 manual Vsam eWay Database Operations JCD

Chapter 6	Section 6.2
Using VSAM Operations	VSAM eWay Database Operations (JCD)

Table 10 VSAM Operations (Continued)

eInsight Operation	Activity Input	Activity Output
SelectOne	where() clause (optional)	Returns the first row that fits
		the condition of the where()
		clause.
Insert	definition of new item to be	Returns status.
	inserted
Update	where() clause	Returns status.
Delete	where() clause	Returns status.

6.2VSAM 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.1The 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

VSAM eWay Adapter User’s Guide 55 Sun Microsytems, Inc.