Scrolling Through a Result Set

Note: Scrollable result sets are supported by JDBC 2.0 and higher.

1. From the Connection window menu, select Connection / Create JDBC 2.0 Statement. DataDirect Test prompts you for a result set type and concurrency.

2. In the resultSetType drop-down list, select TYPE_SCROLL_SENSITIVE. In the resultSetConcurrency drop-down list, select CONCUR_READ_ONLY.

   

   Click Submit; then, click Close.

3. Select Statement / Execute Stmt Query.

4. Specify the Select statement that you want to execute.

   

   Click Submit; then, click Close.

5. Select Results / Scroll Results. The Scroll Result Set window indicates that the cursor is positioned before the first row.

   

6. Click the Absolute, Relative, Before, First, Prev, Next, Last, and After buttons as appropriate to navigate through the result set. After each action, the Scroll Result Set window displays the data at the current position of the cursor.

   

7. Click Close.