Creation wizards that walk you through the process of creating procedural object skeletons.

The SQL Editor lets you create and edit SQL statements and procedural objects using Visual SQL and Content Assist, which lists available syntax options as you write your code.

The Visual SQL dialog is invoked through the SQL Editor context menu and allows you to visually generate SQL syntax without writing SQL code. You can build select, insert, update, and delete statements with clauses, parameters, and variables.

Content Assist shows you the syntax that is available while you are entering SQL code. It filters out illegal syntax at the cursor point so that you choose only from a list of permitted syntax.

SQL file wizard enables developers to organize and save SQL code into SQL files within projects while building, for example, multiple complex procedural objects.

Real-time messaging services include wizards that allow you to generate sophisticated ASE messaging constructs to send and receive messages to and from a queue, publish and consume messages, subscribe to and unsubscribe from topics, and register a subscription for a real-time stored procedure.

Database Explorer displays an object tree from which you can drill down into database objects to view, edit, run, and debug them. If you have more than one database, procedural objects are organized by database connection profile.

WorkSpace Navigator lists, by project, various related SQL files on which you are working. SQL files may contain one or more SQL statements.

Outline view shows the structure of the SQL statement or procedural definition you are editing. Clicking on part of a statement in the Outline view highlights the entire statement in the SQL Editor.

SQL Results view allows you to view the run status, database server messages, and result sets, and save the result sets or results history into different file formats.

The SQL Execution Plan allows you to view the execution plan of a selected SQL statement for performance-tuning purposes.

The ASA Trigger Rows view displays the rows that have errors when debugging an ASA trigger.

The External Client view is used to attach to an external database client session via the isql command tool and debug it using the SQL Debugger.

The Global Variables view displays all the system global variables in read-only format, for use when debugging ASA procedural objects.