SQL Schema Maintenance

SQL Table locations

Shows the path to the project\group SQLDDL subdirectory. If you have assigned any workgroups in your AppMaster Builder preferences, all workgroup locations for the relevant data source type are available on the drop-down list.

Schema location

Shows the path to the project\group SQLSCHEM subdirectory.

SQL Table Definitions

Lists the table definitions found in the project\group SQL DDL data source files.

Moves selected items from the SQL Table Definitions list to the Table Definitions in Schema file list.

Moves selected items from the Table Definitions in Schema file list to the SQL Table Definitions list.

Table Definitions in Schema file

Lists the table definitions to include in the SQL SCHEMA file.

Copylib

Type the name of the copybook file in the project\group CPYLIB subdirectory that contains the COBOL data definitions for the SQL schema. Optional.