Background documentation-2003: Output columns too long Locate this document in the navigation structure

 

Explanation

Possible reasons:

  1. The total length of the output columns exceeds 8084 bytes.

  2. The total length of the output columns, together with the columns specified in the ORDER clause or GROUP clause, exceeds 8084 bytes.

  3. The total length of the output columns, together with the correlated columns and columns of predicates that contain a subquery, exceeds 4048 bytes in an SQL statement with correlated subqueries.

User Response

  1. Reduce the number of output columns.

  2. Try to do without sorting or grouping or to perform sorting or grouping across shorter or fewer columns.

  3. Try to manage with fewer output columns or correlated columns, or to achieve the desired effect using several SQL statements.