DB2 SQL-Error: -540
SQLState: 57001
Short Description: THE DEFINITION OF TABLE IS INCOMPLETE BECAUSE IT LACKS A PRIMARY INDEX OR A REQUIRED UNIQUE INDEX
The table named was defined with a PRIMARY KEY clause, a UNIQUE clause, or with a ROWID column with the GENERATED BY DEFAULT attribute. Its definition is incomplete, and it cannot be used until a unique index is defined for v the primary key (the primary index) v a ROWID column v for each set of columns in any UNIQUE clause (the required unique indexes).An attempt was made to use the table in a FOREIGN KEY clause or in an SQL manipulative statement. System action: The statement cannot be executed. Programmer response: Define a primary index or a required unique index on the table before referencing it.