+20122   DEFINE NO OPTION IS NOT APPLICABLE IN THE CONTEXT SPECIFIED

Explanation

The DEFINE NO option was specified, however it is not applicable in the context specified. DEFINE NO was specified in one of the following situations:
  • a CREATE INDEX statement that included the VCAT clause
  • a CREATE INDEX statement for a non-empty table
  • a CREATE INDEX statement on a declared temporary table
  • a CREATE LOB TABLESPACE statement
  • a CREATE TABLESPACE statement that included the VCAT clause
  • a CREATE INDEX statement for a table that has a defined clone

System action

DB2® ignored the DEFINE NO option and created the object with the DEFINE YES option instead.

SQLSTATE

01644