Максимальный размер индексного ключа в старых версиях был, помнится, 256 байтов, а теперь (начиная с 7.2? уже не помню ;-( ) - 1024. VARCHAR'ы же бывают намного длиннее.

Да, я глюканул - причем здесь индексы? Хотя... помнится мне, что у DB2 2.1 максимальный размер ключа и максимальная сумма длин колонок, участвующих в ORDER BY, совпадали. По-видимому, это и запало мне в душу. Сейчас SQL Limits подрасли.

С другой стороны, перечитывал ли кто описание SQL0134N???

IBM
SQL0134N Improper use of a string column, host variable, constant, or function name.

Explanation: The use of the string name is not permitted.

An expression resulting in a string data type with a maximum length greater than 255 bytes is not permitted in:

* A SELECT DISTINCT statement
* A GROUP BY clause
* An ORDER BY clause
* A column function with DISTINCT
* A SELECT or VALUES statement of a set operator other than UNION ALL.

An expression resulting in a LONG VARCHAR or LONG VARGRAPHIC data type is not permitted in:

* A predicate other than EXISTS or NULL
* A column function
* The SELECT clause of a subquery of a predicate other than EXISTS or NULL
* The SELECT clause of a subselect in an INSERT statement
* The value expression of a SET clause in an UPDATE statement unless the expression is a LONG VARCHAR or LONG VARGRAPHIC host variable
* A SELECT statement of a set operator (except UNION ALL)
* VARGRAPHIC scalar function.

Federated system users: in a pass-through session, a data source-specific restriction can cause this error. See the SQL Reference documentation for the failing data sources.

The statement cannot be processed.

User Response: The requested operation on the string is not supported.

Note:
If it is unclear as to how the 255 byte limit is being exceeded, consider that codepage conversion operations may be required to evaluate the string expression. Depending on the source and target codepages, the target may have a greater length attribute than the source. For more information, refer to the SQL Reference for discussions on string restrictions and string conversions.
sqlcode: -134
sqlstate: 42907