The DDL comparison feature compares the DDL of the source table or view columns with the DDL of the target table or columns prior to copying the table or view. If the table does not already exist on the target system, the comparison is skipped.
When the feature is enabled, the comparison takes place every time the create or move command is used to create a job, or the start command is used to start a job.
DDL Comparison for Tables
- Name
- Type
- Length
- Character type
- Constraint
- Constraint count
- UDT name
- Compressible
- Default value
- Format
- Identity column type
- Nullable
- Stored procedure parameter type
- Upper case flag
- Decimal fraction digits
- Decimal total digits
If any of these values are not the same for the source and target tables, the job fails.
DDL Comparison for Views
DDL comparison for a view compares the columns of the source view with the columns of the source table. It does not compare the definitions of the source and target views. To compare DDL when copying data from a view, the copyData attribute for the view must be set as true.
Scope Levels and Priority Logic
Scope Level | Objects Compared | Priority |
---|---|---|
Object | The specified table or view | Highest |
Database | All tables and views in the specified database | Higher |
Job | All tables and views in the job | High |
Daemon | All tables and views processed by a specific daemon | Low |
Objects Copied | Default Logic |
---|---|
Individual tables and views | True. DDL comparison is performed. |
An entire database | False. DDL comparison is not performed. |