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.

Filter

Type in a string, including wildcard characters, to apply as a filter to the list of SQLDDL members. Alternatively, click one of the alphabetical buttons to provide an initial character for the filter, or click the asterisk (*) button to show all SQLDDL members represented in the project.

Alphabetical buttons

Click an alphabetical button to filter the list of existing SQLDDL members on an initial character. The buttons shown on this dialog box are dynamic, and represent each unique initial character found in the names of SQLDDL members defined in the project.

Asterisk (*) button

Click this to return from filtering to a listing of all SQLDDL members found in the project.

Load

Click this to list SQLDDL members or, when Autoload the list when the filter changes is unchecked, click this to apply the filter to the existing SQLDDL members 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.