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

Chapter 4

Using the VSAM eWay Database Wizard
This chapter describes how to use the VSAM eWay Database wizard to build Object
Type Definitions (OTDs).
What’s in This Chapter
About the Database OTD Wizard on page34
Creating a New VSAM OTD on page 34
Resulting OTD on page 46
Steps to Edit an Existing VSAM OTD on page 47
4.1 About the Database OTD Wizard
The Database OTD Wizard generates OTDs by connecting to external data sources and
creating corresponding Object Type Definitions. The OTD Wizard can create OTDs
based on any combination of Tables, Stored Procedures, or Prepared Statements.
Field nodes are added to the OTD based on the Tables in the external data source. Java
method and parameter nodes are added to provide the appropriate JDBC functionality.
For more information about the Java methods, refer to your JDBC developer’s
reference.
The OTD Wizard allows the addition and removal of columns/nodes in an OTD.
Nodes with the same name and type as existing nodes are allowed by the Wizard, but
should not be created, and will result in generic code generation errors upon activation
of the OTD.
Note: Database OTDs are not messagable. For more information on messagable OTDs, see
the eGate Integrator User’s Guide.
4.2 Creating a New VSAM OTD
The following steps are required to create a new OTD for the VSAM adapter.
Select Wizard Type on page35
Connect To Database on page35