-221 SET OF OPTIONAL COLUMNS
IN EXPLANATION TABLE table-name IS
INCOMPLETE. OPTIONAL COLUMN column-name IS
MISSING
Explanation
The EXPLAIN statement assumes that the required explanation table is defined properly. However, the optional column indicated is not defined in the indicated explanation table.
- table-name
- The name of the explanation table.
- column-name
- The name of the column.
Plan tables must have one of several specific formats. The format chosen must be complete, and each column in the PLAN_TABLE definition must be correct for the chosen format.
System action
The explanation information is not generated.
Programmer response
Correct the definition of the required explanation table to include either all or none of the optional columns in the chosen format.
SQLSTATE
55002