Show TOC

-1002: Too many columnsLocate this document in the navigation structure

Use

Explanation

  1. The maximum number of columns specified under Restrictions for SQL Statements has been exceeded.

  2. A named index can be created across a maximum of 16 columns of a table.

  3. In a referential CONSTRAINT definition, more referencing columns were specified than referenced columns. The number of specified columns in the referencing table must correspond to the specified number of referenced columns in the referenced table.

User Response

  1. Use a QUERY-statement issued on the system table DOMAIN.COLUMNS to find out the current definition of the table. You must not define any further columns.

  2. Correct the number of columns in the index definition.

  3. Use a QUERY statement issued on the DOMAIN.COLUMNS system table to view the complete definition and the key columns of the referenced table.