Executing a Simple Select Statement

This example explains how to execute a simple Select statement and retrieve the results.

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. Specify the Select statement that you want to execute.

   

   Click Submit; then, click Close.

4. Select Results / Show All Results. The data from your result set is displayed.

   

5. Scroll through the code in the Java Code scroll box to see which JDBC calls have been implemented by DataDirect Test.