Viewing and editing routines

You can use the routine editor to edit the source code and properties of a routine, such as a stored procedure or user-defined function.

If you make source code changes using the Routine editor, you must save the routine and then deploy it again to the database server to apply the changes to the server version of the routine.

Restriction: In the Data Source Explorer, you can view routine properties but you cannot change them.

To edit the properties or source code of a routine:

  1. Switch to the Data perspective.
  2. In the Data Project Explorer, double-click a routine. The routine editor opens.
  3. Edit the routine as required.
    1. For SQL routines, type directly on the Source page to make changes to the CREATE statement. You can also modify some routine options on the Configuration page. Some options on the Configuration page are read-only. If you make changes on the Configuration page, click Save Changes and Regenerate Definition to synchronize your changes with the Source page.
    2. For Java™ routines, click the link on the Configuration page to open the Java source in the Java editor, where you can make modifications and save the changes. For example, click PROCEDURE.java. Otherwise, the steps for modifying options on the Configuration page and the Source page is the same for Java routines as it is for SQL routines.
    Content assistance is available in the routine editor. To use content assistance, type a schema or table name followed by a period (.) character to see a list of available tables or columns in the connection that you are working with, or press Ctrl + Space.
  4. Click File > Save to save your changes.
The properties or source code of the routine are changed. If there are errors in either the SQL DDL or the Java source, a warning message is displayed and the line containing the error is annotated with an error marker.

Feedback