VSAM eWay Adapter User’s Guide
49
Sun Microsystems, Inc.
Chapter 5
Using VSAM OTDs
This chapter describes operations you can perform using VSAM Object Type
Definitions (OTDs) in eGate.
What’s in This Chapter
Overview
on page 49
Using Tables
on page 49
Using Views
on page 52
Using Prepared Statements
on page 52
5.1
Overview
This section explains the types of VSAM OTDs used with the eWay within the
Collaboration Editor (Java), including the OTD’s methods.
You can use VSAM OTD methods with:
Tables (table OTD)
Views (view OTD)
Prepared statements (prepared statement OTD)
Views are read-only and for informational purposes only. Use the OTD wizard (see
Chapter 4
) to create the VSAM Database OTDs.
User-defined OTD
You can use the OTD wizard to create an eGate User-defined OTD. See the
eGate
Integrator User’s Guide
for a complete explanation of how to create a User-defined OTD.
5.2
Using Tables
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 setup allows you to perform select, update, insert, and delete
SQL operations in a table.
