To load and build SQL DDL source into a database view

Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
  1. Copy your SQL DDL sources containing native SQL CREATE TABLE statements to the SQLDDL directory of your project.
  2. 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.
  3. Select the SQL DDL Source radio button.
  4. Select a source location on the Source Folder list. This can be a source folder or mainframe location.
  5. From the list of sources, select a file you want to load and build into this database 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.
  6. Click Save/Build. A message box appears when the database view has finished building.
  7. 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 database 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 database 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.