Procedure type
The first dialog box asks for the type of procedure that is to be generated. An example of this follows:
DB2:
Oracle:
SQL Server:
A number of different types of procedure generation are available. Each type is discussed below. There is a check box at the bottom of the dialog box. This check box will only be present if advanced procedure building features are enabled. This check box allows the editing of the 'Where' clause when no table joining is being performed, and hence the where clause would not be exposed.