DDL Tasks tab
Restriction: This topic applies to Windows environments only.
- Available Tasks list
- 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.
