Developing OTDs for Database Adapters

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. Each of the database adapters below provides additional support, such as the Sybase adapter which supports double-byte character set (DBCS). The DBCS is a set of characters in which each character is represented by 2 bytes. The Korean language requires double-byte character sets.

The following sections provide information and instructions on how to create a database OTD.

What You Need to Know

The following topics provide information you should know before creating an OTD for your database type.

• About Database OTDs

• Prepared Statements

  Prepared Statements

• Generating ResultSet Nodes of a Stored Procedure

• DB2 Database Configuration Information

• DB2 Connect Database Connection Information

• JDBC Database Connection Information

• Informix Database Connection Information

• Oracle Database Connection Information

• SQL Server Database Connectivity Information

• Sybase Database Connectivity Information

• VSAM Database Connectivity Information

What You Need to Do

The following topics provide instructions for creating and editing Database OTDs.

• Creating a Database OTD

• Editing Existing OTDs