Any changes you make to the parse options in this page apply to all views. You should parse the views in order for these changes to take effect. You can do this using either the right mouse button or the Parse menu item in the Object menu. Alternatively, you could use the Create Oracle Model item in the Action menu to re-create the Oracle Model.
The Parse Options page of the Views property sheet features the following check boxes:
Auto-Select: This check box is disabled for views.
Function: This check box is disabled for views.
Return Value: This check box is disabled for views.
Procedure: This check box is disabled for views.
Generate Exceptions: Generates PL/SQL exception blocks in the converted view.
Generate comments: Generates comments in the view.
Generate Debug Info: Generates debug information in the view.
Add procedure name to local variables: By default, all local variables within the view are prefixed with the name of the view which helps to distinguish local variables from column names.
Use column name aliases in reference cursor: By default, column names are used to define components within the record structure for result sets. This option forces the Migration Workbench to use its alias whenever possible.
Append procedure name to temp table: Appends the name of the view to the temporary table.
Generate Oracle8i temp tables: Uses Oracle8i syntax to create temporary tables. Otherwise, creates permanent tables with the same name as the temporary tables in the view. The permanent tables have a column added for session ID.
Allow 'Reserved Words' in table names: Some identifiers such as ERROR, DATETIME, and OUTPUT are not official T-SQL reserved words but have meaning in T-SQL syntax. If your T-SQL code uses these words as object names, you must select this check box to enable the parser to recognise that these words are object names. If you do not select this check box, you will encounter a ParseException. See the Appendix of this online Help for more information about parser errors.
Type of result set: This field is disabled for views.
Parameter Handling: This field is disabled for views.
Any changes that you make to the parse options can be applied or abandoned by using the Apply or Revert button.