In the Preferences
window, you can set options for stored procedures
and user-defined function development.
About this task
When you set default settings for stored procedure
and UDF development
in the Preferences window, the settings might be used as follows:
- They can be shown as the defaults in wizards and windows that
use them.
You can override defaults in a situation where the defaults do not
apply.
- They can affect build behavior in the workbench. For
example, in the Process node,
you can specify whether to trace errors. In cases like these, the
behavior
can only be controlled from the Preferences window.
To
change the default options for stored procedure and user-defined
function development:
- Click Window
> Preferences from the main
menu.
- Expand the Data Management node,
the SQL
Development node, and the Stored Procedures
and User-Defined
Functions node to see available options.