From the HCOSS Generate DDL tool, click the
DDL Tasks tab.
Do one of the following:
To define a new DDL task:
Click
New.
In the
Name field, type a name for the DDL task file.
Click
OK.
To edit an existing DDL task, select an existing task from the
Available Tasks drop-down list.
Choose one of the following to apply to the
Available Tasks drop-down list:
Local
To save the generated DDL task file to the directory specified by the
Local HCOSS Directory HCOSS option.
Shared
To save the generated DDL task file to the directory specified by the
Shared HCOSS Directory HCOSS option.
Choose one of the following to apply to the
Associated Transfer List drop-down list:
Local
To show local transfer lists on the
Associated Transfer List drop-down list.
Shared
To show shared transfer lists on the
Associated Transfer List drop-down list.
From the
Associated Transfer Lists drop-down list, select a transfer list file created using the Define Lists tool.
To define the DDL behavior, select either
Drop and create objects or
Restore missing objects.
From the
Connection for Execute drop-down list, select a SQL Server connection previously defined using the Manage Connections tool.
Optionally, do one or more of the following:
To customize your generated DDL, click
Customize. See
To customize generated DDL for more information.
To change the default schema mappings, click
Schema Mappings. See
To customize schema mappings in DLL for more information.
To populate coded character set identifiers (CCSIDs), thus preserving the mainframe text sort order, check
Preserve mainframe text sort order. If left unchecked, the sort order is the default SQL Server order specified for the database.
To check the DDL task specifications against a test SQL Server data source, specify a SQL Server data source in the
Connection for Check drop-down list; then click
Check. Results are displayed on the
Results tab.
To save the SQL generated for the DDL as an SQL script, click
Export SQL Script.
Click
Save to save the DDL task.
Click
Execute.
Click the
Results tab to review the execution results.
