Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




Eclipse Data Tools Platform Guide
Previous Page Home Next Page

Creating a Launch Configuration for Routine Procedural Objects

Use the launch configuration feature to run user-defined functions, events, stored procedures, triggers, and ad hoc queries. Creating your own launch configurations is optional, but it can help you perform more consistent, robust, and efficient iterative testing of routine procedural objects.

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

  1. Select Run > Open Run Dialog Run > Run Configurations from the main menu.
  2. Click New Launch Configuration button New Launch Configuration.

    You can also choose an existing launch configuration by selecting it in the left pane. You can edit it, or duplicate it and use it as a basis for a new configuration.

  3. Enter a unique Name for the launch configuration.
  4. On the Main tab, select a connection Profile and a Database.
  5. Select the object Type.
  6. If basing the launch configuration on an existing object, click Browse to select the object.
  7. In the Run box, complete the execution information.
    Object Description
    Stored procedures, user defined functions, event handlers Click Configure Parameter, and assign values to any parameters.
    Triggers Enter an INSERT, UPDATE, or DELETE statement, or click SQL to visually build the statement using Visual SQL SQL Query Builder.
    Ad hoc SQL Enter the SQL statement, or click SQL to visually build the statement using Visual SQL SQL Query Builder.
  8. (Optional) Click the Options tab to set additional preferences, if the database server support this feature.
  9. (Optional) Click the Common tab to set other attributes for this object.
    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.
  10. Click Apply to accept launch configuration changes.
  11. Click Run to execute the object.

    Results appear in SQL Results view.

  Published under the terms of the Eclipse Public License Version 1.0 ("EPL") Design by Interspire