Database Development

Sybase® WorkSpace database development provides SQL developers and database administrators with visual tools to create and debug database objects. You can create, edit, save, debug, and execute procedural objects, messaging statements, and SQL files. From stored procedures, you can derive database services to integrate with business process services, message services, or Web services using Sybase WorkSpace service development tooling.

The database development tooling includes the following features:

Visual SQL Dialog

Generate SQL syntax without writing SQL code, using Visual SQL Dialog. You can easily write SQL syntax, including select, insert, update, and delete statements.

SQL editor

Create and edit SQL files, procedural objects, and messaging constructs using Visual SQL and Content Assist. Both options list available syntax options as you write the code.

SQL files

Organize and save SQL code into projects for reuse at a later time.

Database Explorer

Drill down through a tree view into database objects to view, edit, run, and debug objects.

Procedural Object and SQL File wizards

Create projects, SQL files, and procedural object skeletons, using wizards to guide you through the processes.

SQL results

View the execution status of procedural objects and their result sets, then save the result sets or results history into a variety of file formats. A Messages tab displays the output messages from the database server.

Real-time messaging

Create messaging statements, such as sending and receiving messages to and from a queue, publishing and consuming messages, and registering subscriptions for real-time stored procedures.

SQL execution plan

View the execution plan of a selected SQL statement to tune performance.

Web service consumer

Access Web service methods via Adaptive Server Enterprise tables.

ASA and Adaptive Server Enterprise portability assistance

Assistance for SQL Editor flags any SQL syntax that cannot be ported between Sybase Adaptive Server Anywhere and Adaptive Server Enterprise.

Database debugging

Provides a full set of views and operations for debugging SQL code.

Database Debugging Views

View	Description
Breakpoint	Facilitates the setting of breakpoints.
Debug	Provides stepping operations which allow you step through SQL statements between breakpoints.
Suspend and Resume Execution Operations	Enables suspending, resuming, and terminating code execution.
Variables	Enables tracking or setting variable values and evaluating expressions.
External Clients	Enables debugging an external database client session.

Opening a Perspective

Database Development Perspective

Services

Real-Time Messaging Services