Sun Microsystems 5.1.3 manual Steps required to create a Vsam Database OTD

Chapter 7	Section 7.6
Implementing the VSAM eWay Sample Projects	Building and Deploying the prjVSAM_JCD Sample Project

ƒVSAM Database OTD

ƒInbound DTD OTD

ƒOutbound DTD OTD

Steps required to create a VSAM Database OTD:

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

2Select the VSAM Database OTD Wizard from the list of OTD Wizards and click Next.

3Enter the connection information for the VSAM database. Connection fields include:

ŠHost name:

ŠPort ID:

ŠDatabase Name:

ŠUser name:

ŠPassword:

4Click 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

5Click Add to select tables from the VSAM database. The Add Tables window appears.

6Search 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

7Click Next the Add Prepared Statements Wizard appears.

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

9Click the OK button to close the Prepared Statement window, and then click Next on the Prepared Statements Wizard window.

10Enter an OTD name. In this example, use otdVSAM.

11Click Next and review your settings, then click Finish to create the OTD.

VSAM eWay Adapter User’s Guide 93 Sun Microsystems, Inc.