< Previous | Next >
WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


Module 3: Creating and modifying a view

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:
This module should take approximately 20 minutes to complete.

Lessons in this module



Feedback

Update icon Last updated: 2007-10-09


< Previous | Next >