Run

There are several ways to run a SQL file or procedural object in the Database Development perspective. Once you have run a procedural object, you can examine the SQL Results view to review its status, as well as any result sets returned from the database. You can remove, save, or export these results. You can select individual queries or a group of SQL commands within the text and execute only that portion of the SQL code using the Execute Selected Text command. You can also view an execution plan for a SQL statement to fine-tune performance.

Executing a SQL File

Running a Stored Procedure

Running a Trigger

Running an ASA Event

Viewing SQL Results

Saving Execution Results

Exporting Execution Results

Obtaining an Execution Plan

Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com