Databases Reference
In-Depth Information
The View Designer window is shown in Figure 6-8.
Figure 6-8 View Designer window
The menu provided in View Designer window includes the following:
View View: Provides ability to check the syntax or test execute the SQL
statement provided in the view definition.
Triggers View: Provides ability to define and add triggers.
Privileges View: Allows adding roles and privileges to users.
Show Script View: Shows the create view statement.
IBM Procedure Designer
The IBM Procedure Designer can be used to create a new procedure by
right-clicking
Procedures
node in Server Explorer, under
Data Connections
→
database
, then selecting
Add New SQL Procedure with Designer
as shown in
Figure 6-9 on page 263.
Search WWH ::
Custom Search