This example explains how to execute a simple Select statement and return the results.
To Execute a Simple Select Statement:
1. From the Connection window menu, select Connection / Create Statement. The Connection window indicates that the creation of the statement was successful.
2. Select Statement / Execute Stmt Query. DataDirect Test displays a dialog box that prompts for a SQL statement.
3. Type a Select statement and click Submit. Then, click Close.
4. Select Results / Show All Results. The data from your result set displays in the JDBC/Database Output scroll box.
5. Scroll through the code in the Java Code scroll box to see which JDBC calls have been implemented by DataDirect Test.