Product specifications

13.1.23 ORDER_BY
<Parameter Name="ORDER_BY">YES</Parameter>
Specifies if the database supports the ORDER BY clause.Description
YES: the database supports the ORDER BY clause.
NO: the database does not support the ORDER BY clause.
Values
13.1.24 ORDER_BY_REQUIRES_SELECT
<Parameter Name="ORDER_BY_REQUIRES_SELECT">NO</Parameter>
Specifies if the database requires columns used in the ORDER BY
clause to be referenced in the SELECT statement.
Description
YES: users are not allowed to sort on columns if they are not included
in the SELECT statement. In this case, the Manage Sorts button is
greyed in the Query Panel of the universe design tool.
NO: users are allowed to sort on columns even if they are not included
in the SELECT statement.
Values
NO
Default
13.1.25 ORDER_BY_SUPPORTS_COLUMN_INDEX
<Parameter Name="ORDER_BY_SUPPORTS_COLUMN_INDEX">YES</Parameter>
2012-03-15170
PRM parameter reference