Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Reference : Components of the DB Navigator perspective : SQL Editor
 
SQL Editor
The SQL Editor allows you to view, write, and execute SQL scripts.
In the edit area, you can enter one or multiple SQL statements. Multiple statements are delimited with a semicolon. You can modify the delimiter in the Progress DB Navigator preferences.
If you enter a dot after a schema name or a catalog name, the auto-completion menu appears showing all tables. A secondary menu shows all columns within that table. A menu of all columns is displayed upon entering a dot after the table.
The toolbar of the editor contains the following controls:
Execute the SQL statement(s).
Note: The Execute icon is disabled until you select a database.
Select and open an existing .sql file.
Clear all content from the editor.
Select a database connection. When you are creating a new script, the default is the connection that is selected in the Connections view.
Note: If more than one catalog exists, another drop-down list appears in which you specify which catalog to use.
You can choose to enable auto-completion assistance for columns within the SQL Editor. Enabling auto-completion allows you to type any letter in the SQL Editor, and then type the CTRL+SPACE keyboard combination to see if there are multiple words that match. If the letter you type has only one match, that key word is entered into the editor.
To enable auto-completion for columns, select the Columns auto-completing assistance option from the Progress DB Navigator preferences page.
Note: Be aware that auto-completion can slow performance during connection.