Creating a Launch Configuration for Procedural Objects

Use the Eclipse launch configuration mechanism to run stored procedures, triggers, SQL Anywhere/Sybase IQ user-defined functions, and events. Creating your own launch configurations is optional, but it can help you do more consistent, robust, and efficient iterative testing of procedural objects.

The tooling creates a launch configuration automatically using the name, connection profile name and type, and object type of the procedural object. You can create additional launch configurations with different launch properties. For example, you can specify different parameters or ad hoc SQL statements.

Find the procedural object and click it to select it.
Stored procedures, event handlers, and user-defined functions reside in folders under the schema owner. Triggers reside in a folder under the navigation tree for the table.
Select Run > Open Run Dialog from the Sybase WorkSpace toolbar to invoke the Run dialog.
The Create, manage, and run configurations page appears.
Enter a unique name for the launch configuration in the Name field.
On the Main tab, specify the object for which you are creating a launch configuration:
- Select a connection profile from the Profile drop-down list and a database from the Database drop-down list in the Profile frame.
- Click the object type in the Type frame.
  
  The type determines which fields you complete in the remaining steps.
- Click Browse, and select the object to be launched.
For Ad hoc SQL, modify the SQL statement in the Run dialog manually, or click SQL to use Visual SQL.
(Optional) Click Configure Parameter, and assign values to any parameters in the Configure Parameters dialog.
To revert all values to their defaults, click Load Defaults and then OK to return to the Create, Manage, and Run Configuration dialog.
Database Development tooling tries to convert any value you enter that does not meet requirements for the parameter. Make sure the converted value is correct.

(Optional) Click the Common tab to set attributes that are common among most objects you can run in Eclipse.

These values apply only to the procedural object you are launching.

Table 1. Common launch configuration attributes
Field	Explanation
Save as	Specify where to save the launch configuration: Choose Local file to make it available to this project only. Choose Shared file to make it available to other projects.
Display in favorites menu	Click Debug or Run to display the configuration in a favorites menu.
Console Encoding	(Optional) Click Other, and select an encoding to override Export Format preferences.
Standard Input and Output: Allocate Console	Select Allocate Console if the object requires input. (Default.)
Standard Input and Output: File	(Optional) Click File to choose a location for file output: Click Workspace to select a project resource to which to redirect output. Click File System to save the output as a file. Click Variables to select and configure a variable for output.
Standard Input and Output: Append	(Optional) Click Append to append output from each launch to the existing file. Otherwise each launch overwrites previous output.
Launch in background	Click to control whether the object runs in the foreground or background.

Click Apply to accept launch configuration changes, or Revert to reset them.
Click Run to execute the procedural object.
Results appear in SQL Results view.