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:
- Switch to the Data perspective.
- In the Data Project Explorer, double-click a routine. The
routine editor opens.
- Edit the routine
as required.
- 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.
- 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.
- Click 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.