search cancel

RCM; Will the Syntax checker flag incomplete table definitions related to Indexes?


Article ID: 240101


Updated On:


RC/Migrator for DB2 for z/OS


 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:

Incorrect DDL statements or object dependency problems are displayed in the Syntax Checker Report, along with
messages describing the problems.

The Syntax Checker does not put any locks on the DB2 catalog, so you can check a stream for errors without
interrupting any other DB2 process.

The Syntax Checker does not perform DATA TYPE validations on index VALUE clauses or in VIEW text.  It checks DDL
only; it does not check grant statements.


The syntax checker is not going to determine a Unique constraint does not have a matching index with the correct columns.