Product specifications

YES: the database supports complex expressions in the GROUP BY
clause.
NO: the database does not support complex expressions in the GROUP
BY clause.
Values
NO
Default
13.1.10 GROUP_BY_SUPPORTS_CONSTANT
<Parameter Name="GROUP_BY_SUPPORTS_CONSTANT">YES</Parameter>
Specifies if the database supports the use of constant objects in the
GROUP BY clause. This parameter is used by IBM DB2 and Microsoft
SQL Server databases.
Description
YES: the database supports the use of constant objects in the GROUP
BY clause.
NO: the database does not support the use of constant objects in the
GROUP BY clause.
Values
YES
Default
13.1.11 HAVING
<Parameter Name="HAVING">NO</Parameter>
Specifies if the database supports the HAVING clause in SQL state-
ments.
Description
2012-03-15164
PRM parameter reference