In this module, you will use the SQL builder to create a view.
This tool has an extensive set of features, many of which are supported by
Classic Data Architect. In this module, you will use only some of the available
features.
You can create a view in Classic Data Architect in any of these
ways.
- With the New Table Wizard when you create a table
- You can create a view at the same time that you create the table that
the view references. For example, the New VSAM Table wizard that you used
in Module 2 has a Create View option. All wizards that
you use to create a table have the same option. If you choose to create a
view, the wizards let you select the columns of the table that you want to
reference and create a WHERE clause.
- By adding a view object and specifying properties
- You can create a view by right-clicking a schema in your project and selecting Add
Classic Object > View. You can use the Properties view to specify
the different attributes of the view.
- With the SQL editor
- You create a SELECT statement with the SQL editor. You start from a brief
template for the SELECT statement and then write the rest of the statement
yourself.
- With the SQL builder
- The SQL builder builds the SELECT statement for you as you select options.
Learning objectives
After completing the
lessons in this module you will understand the concepts and know how to do
the following tasks:
- Use the SQL builder to create a simple SELECT statement
- Test the SELECT statement
- Create and rename a view that is based on the SELECT statement
- Promote the view to the metadata catalog of a data server
- Test the view on the data server
- Grant privileges on the view
This module should take approximately 20 minutes to complete.