Background documentation-2013: Select column list too long Locate this document in the navigation structure

 

Explanation

Possible reasons:

  1. In the CREATE VIEW statement, the number of view table columns to be defined must be equal to the number of columns issued as the result of the QUERY expression. In the present case, the number of columns in the QUERY request result exceeds the number of defined view table columns.

  2. The number of subquery output columns specified in a SET UPDATE clause must be precisely one. In some SQL modes, this restriction also applies in the comparison predicate, quantity comparison predicate and IN predicate. In this case, the subquery produced more than one output column.

  3. An SQL statement was specified for data retrieval. The number of output columns must be less than or equal to 254. This number was exceeded.

User Response
  1. Increase the number of view table columns specified in the CREATE VIEW statement, or reduce the number of output columns of the QUERY expression.

  2. Limit the number of subquery output columns to one.

  3. Correct the data query statement by removing one or more output columns.