Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
- Copy your SQL DDL sources containing native SQL CREATE TABLE statements to the
SQLDDL directory of your project.
- 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 DDL Source radio button.
- Select a source location on the
Source Folder list. This can be a source folder or mainframe location.
- From the list of sources, select a file you want to load and build into this data view and click
Load. The file can be SQL DDL file, mainframe file, or workgroup file. A message box indicates if 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 DDL loaded
successfully.
Note:
- 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.
- A message box alerts you if the Subschema name in the CREATE statement does not match the data view name. If this happens,
click
OK to clear the message, then adjust the subschema name in the CREATE statement before reloading the source file.
- You can load any SQL DDL source file into this data view if the source file does not contain a CREATE SUBSCHEMA statement.
However, it is recommended to load SQL tables using a SQL schema instead of loading them directly from the SQL DDL.