-220 THE COLUMN column-name IN EXPLANATION TABLE table-name IS NOT DEFINED PROPERLY
Explanation
An error occurred during the insertion of a row into the EXPLAIN table.
- column-name
- The name of the column that caused the error. If the column definition is incorrect, column-name is the name of the column in error. Otherwise, *N is returned for column-name because the column name is not applicable.
- table-name
- The name of the EXPLAIN table.
Possible reasons for this error include:
- A column is missing.
- Columns are defined in the wrong order.
- The table contains an extra column.
- A column description is invalid because of its name, data type, length, or null attributes.
- The SQL statement contains contains mixed data, and the EXPLAIN table was defined as CCSID EBCDIC.
System action
The statement cannot be processed. The EXPLAIN information is not generated.
Programmer response
Correct the definition of the required
EXPLAIN table. If the SQL
statement being explained contains mixed data and the EXPLAIN table
is defined as CCSID EBCDIC, take the following actions:
- Copy the data from the EXPLAIN table.
- Drop the EXPLAIN table.
- Re-create the EXPLAIN table with CCSID UNICODE.
- Copy the data into the EXPLAIN table.
SQLSTATE
55002