Using the SQL Editor

Go Up to Coding Environments/Editors

DBArtisan incorporates a powerful SQL scripting environment, the SQL Editor. The SQL Editor lets you write, debug, test and deploy solid SQL code for your database applications.

You can open multiple SQL windows. In addition, when you open an SQL file, it opens in an SQL Editor window. For more information, see Opening Files.

To open a SQL Editor window

1. Connect to the datasource that you want to write a script against and ensure that it is the active datasource. For more information, see Connected/Selected Datasource options.
2. On the File menu, select New ISQL.

   An SQL Editor window opens in your current workspace.

The following topics provide details on functionality specific to the SQL Editor:

• SQL Editor Windows Basics
• Valid Content in the SQL Editor
• Automated Error Detection and Coding Aid Features
• Execution and Execution-related SQL Editor options
• Using the Results Editor
• Miscellaneous SQL Editor Tasks

See the following topics for information that the SQL Editor shares with other DBArtisan environments:

• Common Word-processing Operations
• Common Coding Environment Features

Note: The Tools menu offers a number of code generation and execution utilities that can be used in conjunction with the SQL Editor. For details, see Tools.