Creating a Launch Configuration for Procedural Objects

Use the launch configuration feature 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 perform more consistent, robust, and efficient iterative testing of procedural objects.

WorkSpace 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 an existing procedural object.

Procedural object	Description
Stored procedures	Expand the Stored Procedures folder.
SQL Anywhere or Sybase IQ User-defined functions	Expand the User Defined Functions folder.
Triggers	Expand the Tables folder, select the table in which the trigger resides, and then expand the Triggers folder.
SQL Anywhere or Sybase IQ events	Expand the Events folder.

Click the procedural object and then select Run > Open Run Dialog from the main menu.
Enter a unique Name for the launch configuration.
On the Main tab, specify the object for which you are creating a launch configuration:
1. Select a connection Profile and a Database.
2. Click the object type in the Type frame. The type determines which fields you complete in the remaining steps.
3. Click Browse, and select the object to be launched.
For Ad Hoc SQL, modify the SQL statement, or click SQL to use Visual SQL.
(Optional) Click Configure Parameter, and assign values to any parameters.
To revert all values to their defaults, click Load Defaults and then OK.
Database Development 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.

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: Select Local File to make it available to this project only. Select 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	Indicates that the object runs in the background.

Click Apply to accept launch configuration changes.
Click Run to execute the object.
Results appear in SQL Results view.