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 Database View Explorer of the AppMaster Builder perspective, right-click to select the desired database view and choose
Edit Database View. The
Load Source for Database 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 database 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 database 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 database view with the same name as your SQL SCHEMA already exists, your schema is built into that existing database
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 database view if the SUB name specified in the VSAM matches the name of the database
view.
- You can load IMS into this same database view if the name of the PSB source matches the name of the database view.