Filter
Top Products
Chapter 4 Section 4.2
Using the VSAM eWay Database Wizard Creating a New VSAM OTD
VSAM eWay Adapter User’s Guide 42 Sun Microsystems, Inc.
Steps Required to Add Prepared Statements Include:
Note: When using a Prepared Statement, the ‘ResultsAvailable()’ method will always
return true. Although this method is available, you should not use it with a ‘while’
loop. Doing so would result in an infinite loop at runtime and will stop all of the
system’s CPU. If it is used, it should only be used with the ‘if’ statement.
1 On the Add Prepared Statements window, click Add.
Figure 13 Prepared Statement
2 Enter the name of a Prepared Statement or create a SQL statement by clicking in the
SQL Statement window. If you are not logging into the VSAM database with the
default user name, you must enter the Table schema name in the SQL Prepared
Statement. 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 14.