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 use the Result Set tab in SQL Results to review its status, as well as any result sets returned from the database. You can remove or save 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. From SQL Results, you can view an execution plan to fine-tune performance.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com