To load and build a SQL schema into a data view
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
- Copy the SQL DDL sources that contain the tables you want to reference in your SQL schema to the
SQLDDL directory of your project or group.
- In the Data View Explorer of the AppMaster Builder perspective, right-click to select the desired data view and choose
Edit Data View. The
Load Source for Data View dialog box appears with the
Sources tab selected.
- Select the
SQL Schema Source radio button.
- From the list of source members, select the SQL schema you want to load and build into this data view and click
Load. A message box indicates when the source has been loaded in to the database file. Click
OK to clear the message box.
- Click
Save/Build. A message box appears when the data view has finished building.
- Click
OK to return to the AppMaster Builder Desktop. Review the information in the Logger window to ensure that your SQL schema loaded successfully.
Note:
- If a data view with the same name as your SQL SCHEMA already exists, your schema is built into that existing data view.
- You can change the default SQL target information for this session on the
Properties tab for the Load/Build Data Views dialog box. The properties revert back to the default settings when you close the Load/Build Data Views dialog box.
- You can also load VSAM source into this data view if the SUB name specified in the VSAM matches the name of the data view.
- You can load IMS into this same data view if the name of the PSB source matches the name of the data view.
