Adding Data Views

Data View Add Process

The data view add process does the following:

• Creates a data view meta data file in the DDIMETA project directory. This file describes the data view and bears the same name as the data view. It is updated each time a change is made to the data view. Do not edit this file.
• Adds the data view to the AMB Data View Explorer.

Data View Naming Guidelines

The name you choose for a data view is important. Before you create it, determine which data sources you intend to include, and use these guidelines to help you choose an appropriate name based on the types of data source selected for inclusion:

IMS PSB and DBD

Give the data view the same name as the PSB source file that contains the DBD names you want to load into the data view.

IMS DB DDI

The name of the data view is not dependent on IMS DB DDI information.

VSAM DDI

Give the data view the same name as the VSAM DDI file you code.

SQL DDL

If the SQL DDL source you intend to add to this data view contains a CREATE SUBSCHEMA statement, the name of the data view must be the same name as is specified in the CREATE SUBSCHEMA statement. If your SQL DDL does not contain a CREATE SUBSCHEMA statement, then the name of the data view is not dependent on SQL DDL information.

SQL SUBSCHEMA

Choose a name that describes the collection of tables you want to reference in this data view. AppMaster Builder uses the name you assign here to generate a CREATE SUBSCHEMA statement for this data view.

Multi-type Data Views

If your data view is to contain a combination of database types, keep in mind that the name you choose for the data view could mean that you must make some changes in the data source you load. For example, to combine in one data view both PSB source and SQL DDL source that contains a CREATE SUBSCHEMA statement, the name of the PSB source file and the name specified in the CREATE SUBSCHEMA statement must both match the name of the data view.

In addition, data view names can be a maximum of eight characters.