You cannot specify long binary/varchar column in the ORDER/GROUP by clause or in an aggregate function. %1
| Item | Value | 
|---|---|
| SQLCode | -1001054L | 
| Constant | EMSG_LOB_NOT_ALLOWED_GROUP | 
| SQLState | QFA50 | 
| ODBC State | ERROR | 
| Parameter 1 | location of the exception | 
This error is reported when you attempt to use a LONG BINARY column in an ORDER BY, GROUP BY, or aggregation clause.