Sun Microsystems eWay JDBC/ODBC Adapter - Manual (Page 53)

Chapter 4 Section 4.2
Using the JDBC/ODBC eWay Database Wizard Creating a New JDBC OTD
JDBC/ODBC eWay Adapter User’s Guide 53 Sun Microsystems, Inc.
Figure 22 Prepared Statement
2 Enter the name of a Prepared Statement or create a SQL statement by clicking in the
SQL Statement window. When finished creating the statement, click Save As giving
the statement a name. This name will appear as a node in the OTD. Click OK. See
Figure 23.
Figure 23 Prepared SQL Statement
3 On the Add Prepared Statement window, the name you assigned to the Prepared
Statement appears. To edit the parameters, click Edit Parameters. You can change
the datatype by clicking in the Type field and selecting a different type from the list.
4 Click Add if you want to add additional parameters to the Statement or highlight a
row and click Remove to remove it. Click OK. Figure 24.