Database Development uses the Eclipse launch configuration mechanism to run stored procedures, triggers, ASA user-defined functions, and ASA events. To run a procedural object, you may first want to create a launch configuration for the object:
Expand the ASA or ASE connection profile in Database Explorer and open a stored procedure, trigger, ASA user-defined function, or ASA event in SQL Editor either by double-clicking the object or by selecting it, right-clicking it, and selecting Edit.
Select Run|Run from the Sybase WorkSpace toolbar to invoke the Launch Configuration wizard. The Create, Manage, and Run Configuration page appears.
Select Configurations|Sybase Database Development. Select the Debug and Run perspectives you want associated with this configuration. Select None if you do not want perspectives.
Click New to return to the full Create, Manage, and Run Configuration page.
Click the appropriate option button in the Type frame for the type of object for which you are creating a launch configuration.
Click Run if you have no parameters to configure.
SQL Editor displays the procedure and the results appear in SQL Results view.
Click Configure Parameter... to assign values to any parameters. The Configure Parameters dialog appears.
Enter any values for the parameters that appear. Click OK. The Create, Manage, and Run Configuration reappears.
Click Apply to apply the new values to the procedural object's parameters.
Click Run to execute the procedure.
SQL Editor displays the procedure and the results appear in SQL Results view.
The following Related Tasks describe alternate ways to open the Launch Configuration wizards, with detailed configuration steps for the different types of procedural objects.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com