To select SQL, choose the Query-language option from the main menu. Press the Q key or highlight the Query-language option and press RETURN. The Query-language option displays the SQL menu, as Figure 8 shows.
SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit
Enter new SQL statements using the SQL editor.
------------------------------------------------Press CTRL-W for Help -----If you select the Query-language option on the main menu and have not selected a database, the SELECT DATABASE screen appears. Specify a database at the prompt or press the Interrupt key to display the SQL menu. From the SQL menu, create or choose and run an SQL statement to specify the current database.
The SQL menu has the following options.
| Option | Purpose | Instructions |
|---|---|---|
| New | Clears current statements and positions cursor in SQL editor. | Entering a New SQL Statement |
| Run | Executes current SQL statements. | Running an SQL Statement |
| Modify | Allows you to modify current SQL statements in SQL editor. | Modifying an SQL Statement |
| Use-editor | Invokes a system editor so that you can modify current statements or create new statements. Use-editor is interchangeable with New and Modify. | Using a System Editor |
| Output | Redirects Run-option output to a file, printer, or system pipe. | Redirecting Query Results |
| Choose | Lists SQL command files so that you can choose a file to execute or modify. | Choosing an Existing SQL Statement |
| Save | Saves current SQL statements in a file for later use. | Saving the Current SQL Statement |
| Info | Displays table information, such as columns, indexes, privileges, constraints, triggers, status, and fragmentation strategy. | Displaying Table Information |
| Drop | Deletes a specified SQL command file. | Dropping an SQL Statement |
| Exit | Returns to main menu. | none |