Go Up to isql Menus
The Query menu contains the following entries:
Load Scriptloads a SQL script file
Save Scriptsaves a SQL script file
Nextsteps you forward to the next SQL statement after you have used the Previous command to display earlier statements in the stack.
Previousdisplays the previous statement that you entered in the input area. This command can be used repeatedly to step through the stack of statements entered during the current interactive SQL session.
Executeexecutes the SQL statements currently displayed in the input area.
- Execute Selection executes the selected portion of the SQL statement displayed.
Fetch Allforces the IBConsole to fetch all the rows of a subquery rather than a subset. Rarely needed, because IBConsole fetches the results as you scroll down in the output area.
Preparedisplays the optimization plan in the SQL output area.
- Cancel exits the optimization plan.
Save Outputsaves the contents of the output area to a text file.
- Wizard opens the Query Wizard where you can create query scripts.