Object modes and violation detection in dbschema output

The output from the dbschema utility shows object modes and supports violation detection.

The dbschema output shows:
  • The names of not-null constraints after the not-null specifications.

    You can use the output of the utility as input to create another database. If the same names were not used for not-null constraints in both databases, problems could result.

  • The object mode of objects that are in the disabled state. These objects can be constraints, triggers, or indexes.
  • The object mode of objects that are in the filtering state. These objects can be constraints or unique indexes.
  • The violations and diagnostics tables that are associated with a base table (if violations and diagnostics tables were started for the base table).

For more information about object modes and violation detection, see the SET, START VIOLATIONS TABLE, and STOP VIOLATIONS TABLE statements in the HCL OneDB™ Guide to SQL: Syntax.