Defining Data Views

Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
Important: You can add data source files created outside of the AMB environment, or create new data source files in AMB as you add them to data views. This documentation assumes that each added data source file, with the possible exception of SQL SCHEMA files, was created outside of the AMB environment; however, we do provide instructions for creating new data source files in AppMaster Builder if that is your preference. See To create new data source files in AppMaster Builder for details.

You define an AppMaster Builder data view by adding data source files. When you add a data source file to a data view, AMB:

IMS data sources

To add IMS data sources to a data view, you can choose from several methods:

PSB method (preferred)
The Data View feature allows you to first add a PSB data source to a data view, and then automatically add the DBD sources referenced by the PSB as well as any DDI IMS DB sources that reference the added DBD sources. For instructions, see To add IMS data sources from a PSB file.
IMSPSB override method
This method enables you to add an independent, specific DDI IMS DB source at the same time as referenced DDI IMS DB source is added via the PSB method. Do this by setting the Add DDISRC with IMSPSB override option in the data view properties, specifying a DDI IMS DB file to load, before adding DBDs and DDI IMS DB referenced from the PSB. See To set data view properties for more information.
Individual sources method
You can add PSB, DBD, and DDI IMS DB sources one at a time, independent of each other.

DDI VSAM source

For any given data view, simply add one DDI VSAM source file.

SQL data sources

You can choose from these three methods to add SQL DDL source to a data view:

Assemble SQL Schema method (preferred)
To add SQL DDL using this method, you first create an empty SQL Schema file from the Data View Explorer, and then define the CREATE SUBSCHEMA statement by selecting tables using the SQL Schema Maintenance dialog box. The SQL DDL data sources that contain the selected tables are automatically added to the data view. See To define or modify a SQL SCHEMA file for details.
Code SQL Schema method
You can add a manually coded SQL schema data source. The SQL DDL data sources that contain the tables defined in the CREATE SUBSCHEMA statement are automatically added to the data view. See Coding SQL Schema Sources and To define or modify a SQL SCHEMA file for details.
SQL DDL data source method
Add one native SQL DDL source file.