-637   DUPLICATE keyword-name KEYWORD OR CLAUSE

The SQL statement contains a duplicate specification for the keyword-name key word. For example:

• DEFAULT, UNIQUE, and PRIMARY can only be specified once in a column definition.
• UNIQUE and PRIMARY cannot both be specified for the same column definition.
• PRIMARY can only be specified once in a CREATE TABLE statement.
• The attribute-string specified in the ATTRIBUTES clause of the PREPARE statement cannot specify an option more than once.
• ACTIVATE or DEACTIVATE ROW ACCESS CONTROL can only be specified once.
• ACTIVATE or DEACTIVATE COLUMN ACCESS CONTROL can only be specified once.
• IN ACCELERATOR can only be specified once.
• ATTRIBUTE ENCRYPTION can only be specified once in a TRUSTED CONTEXT definition.
• There are more than one xquery-context-item-expression in the PASSING clause of an XMLQUERY or XMLEXISTS.
• WHEN MATCHED and WHEN NOT MATCHED clauses cannot be specified more than once in a MERGE statement.
• SKIP LOCKED DATA clause cannot be specified more than once for:
  • all clauses in select-stmt
  • SELECT INTO statements
  • search UPDATE statements
  • search DELETE statements
• If multiple ADD COLUMN clauses are specified in the same statement, at most one ADD COLUMN clause can contain a references-clause.