Create View panel
You use the Create View panel to create a new view.
Panel and field definitions
Process Options Utilities Help
FM/Db2 (DFG2) Create View Top of data
View:
Owner . . . . . . . + (optional)
Name . . . . . . . +
Fullselect clause (required)
+
Column names (optional, separated by commas)
+
With Check Option (Optional):
Option
1. With Cascaded Check Option
2. With Local Check Option
Command ===>
F1=Help F2=Split F3=Exit F4=Expand F7=Backward F8=Forward
F9=Swap F10=Left F11=Right F12=Cancel
- Owner
- The name of the owner of the view.
- Name
- The name of the view to be created.
- Subselect clause
- SQL subselect clause defines the contents of the view.
- Column names
- A list of column names defining the names of the view columns. Must be specified if the subselect clause result table contains duplicate or unnamed columns. If specified, must contain the same number of columns as the subselect clause result table.
- With Check Option
- Controls whether or not inserted rows must conform to the view
definition.
- 1. With Cascaded Check Option
- Generates WITH CASCADED CHECK OPTION clause.
- 2. With Local Check Option
- Generates WITH LOCAL CHECK OPTION clause.
Parent panels
Child panels
None.