select
...
dda.attribute_value as direct_allocation ,
dda1.attribute_value as residue_allocation
from
db.run rn
...
left join db.dmg_db_attr  dda
on ddk.db_id = dda.db_id and dda.attribute_name='MailSort.Direct'
left join db.dmg_db_attr  dda1
on ddk.db_id = dda1.db_id and dda1.attribute_name='MailSort.Residue'
WHERE
rn.report_index =  8 
....
GROUP BY GROUPING SETS
((..., ..., dda.attribute_value, dda1.attribute_value),
(..., ..., ...))
ORDER BY
..., ..., ..., ....

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