If a DB2 table is created with an incomplete definition, for example;
>> A table has a Unique constraint and there is not a matching Unique Index.
>> A primary key constraint does not have a matching index.
Will Syntax checker flag these?
Release : 20.0
Component : RC/Migrator for DB2 for z/OS
The syntax checker does not flag incomplete DDL. The syntax checker is only validating the provided DDL is syntactically correct.
The Help panel explains:
The syntax checker is not going to determine a Unique constraint does not have a matching index with the correct columns.