Sun Microsystems SUN SEEBEYOND eWAY, User Manual, Page: 93 / 115

Chapter 7 Section 7.6
Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project
VSAM eWay Adapter User’s Guide 93 Sun Microsystems, Inc.
ƒ
VSAM Database OTD
ƒ
Inbound DTD OTD
ƒ
Outbound DTD OTD
Steps required to create a VSAM Database OTD:
1 Right-click your new Project in the Enterprise Designer’s Project Explorer, and
select
New > Object Type Definition .
The New Object Type Definition Wizard window appears.
2 Select the
VSAM Database OTD Wizard
from the list of OTD Wizards and click
Next .
3 Enter the connection information for the VSAM database. Connection fields
include:
Š
Host name:
Š
Port ID:
Š
Database Name:
Š
User name:
Š
Password:
4 Click Next , and select the types of database object you want to include in the
sample Project. For our example, select the following:
Š
Tables/Views/Aliases
Š
Prepared Statements
5 Click Add to select tables from the VSAM database. The Add Tables window
appears.
6 Search for or Type in the name of the database. In this example we use the
CICSEMP
table. Click
Select
when the database appears in the Results selection
frame. Click OK to close the Add Tables window
7 Click
Next the Add Prepared Statements Wizard appears.
8 Click Add , the Add Prepared Statement window appears. Enter the following:
Š
Prepared Statement Name: Select_ps
Š
SQL Statement:
select * from CICSEMP where EMPID > ? order by EMPID
Note: In this example, the SQL statement includes the ? placeholder for input. This
placeholder represents the Where Clause.
9 Click the
OK
button to close the Prepared Statement window, and then click
Next
on the Prepared Statements Wizard window.
10 Enter an OTD name. In this example, use
otdVSAM
.
11 Click Next and review your settings, then click Finish to create the OTD.