DB2 SQL-Error: -221
SQLState: 55002
Short Description: SET OF OPTIONAL COLUMNS IN EXPLANATION TABLE IS INCOMPLETE OPTIONAL COLUMN IS MISSING
The EXPLAIN statement assumes the required explanation table is defined properly. The optional column indicated is not defined in the indicated explanation table. 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. The allowed formats for the PLAN_TABLE are described in Chapter 6 of DB2 SQL Reference. System action: The explanation information is not generated. Programmer response: Correct the definition of the required explanation table to include all of the optional columns in the chosen format, just the Version 2 Release 2 optional columns, or no optional columns. Refer to Chapter 5 of DB2 SQL Reference for information on defining an explanation table.