List of previously created local or shared generated DDL tasks.
Available Tasks Local button
Show local DDL tasks on the
Available Tasks list.
Available Tasks Shared button
Show shared DDL tasks on the
Available Tasks list.
Associated Transfer List list
List of local or shared transfer lists created using the Define Lists tool.
Associated Transfer List Local button
Show local transfer lists on the
Associated Transfer List list.
Associated Transfer List Shared button
Show shared transfer lists on the
Associated Transfer List list.
New
Create a new DDL task.
Save
Save the DDL task specified in the
Available Tasks field.
Revert
Set changed fields and controls back to their last saved state.
Delete
Delete the DDL task specified in the
Available Tasks field.
Drop and create objects
The generated DDL drops and creates objects in the destination SQL Server database. Default.
Restore missing objects
The generated DDL restores missing objects in the destination SQL Server database.
Connection for Check
The name of the SQL Server connection you want to use to test DLL task specifications. This defaults to the SQL Server data
source specified for the
Data source to use for testing DDL HCOSS Option, if set.
Connection for Execute
The name of the SQL Server connection you want to use when executing the DDL. This defaults to the SQL Server data source
specified for the
Name of the current/default target data source HCOSS Option, if set.
Preserve mainframe text sort order
When checked, HCOSS populates coded character set identifiers (CCSIDs), preserving the mainframe text sort order. If unchecked,
the sort order is the default SQL Server order specified for the database. Default is unchecked.
Check
Checks the DDL task specifications against the SQL Server data source specified as the
Connection for Check, and takes you to the
Results tab to view the results of the check.
Execute
Generates the DDL and then executes it against the SQL Server data source specified as the
Connection for Execute, and takes you to the
Results tab to view the results.
Customize
Takes you to the
Customize DDL tab where you can customize the SQL generated for the DDL.
Schema Mappings
Takes you to the
Schema Mappings tab where you can change the name of your SQL Server schema.
Export SQL Script
Save the SQL generated for the DDL as an SQL script.