Product specifications

13.1.8 GROUP_BY_SUPPORTS_COLUMN_INDEX
<Parameter Name="GROUP_BY_SUPPORTS_COLUMN_INDEX">NO</Parameter>
Specifies if the database supports the use of column indexes from the
SELECT statement in the GROUP BY clause.
Description
YES: the database supports the use of column indexes from the SELECT
statement instead of column names.
NO: the database does not support the use of column indexes from the
SELECT statement instead of column names.
Values
NO
Default
13.1.9 GROUP_BY_SUPPORTS_COMPLEX
Parameter Name="GROUP_BY_SUPPORTS_COMPLEX">NO</Parameter>
Specifies if the database supports complex expressions in the GROUP
BY clause. Complex expressions mean anything than column names
or indexes present in the SELECT statement, for example functions or
columns absent from the SELECT statement. This parameter is used
with IBM DB2.
Note:
If you run a query containing measure objects and complex objects, that
is, objects using functions and concatenation, your application displays
the following error message: Your database does not allow
you to do aggregations with the <object name> object
.
Description
2012-03-15163
PRM parameter reference