Product specifications

YES: the database supports random sampling.
NO: the database does not support random sampling.
Values
YES
Default
13.1.4 DISTINCT
<Parameter Name="DISTINCT">YES</Parameter>
Specifies if the database supports the DISTINCT keyword in SQL
statements. This parameter is used with MS Access.
Description
YES: the database supports the DISTINCT keyword.
NO: the database does not support the DISTINCT keyword. This behavior
disables the following features:
• the Distinct Values option that appears when you click the View
Values button in the Quick Design wizard of the universe design
tool.
• The Countdistinct function that appears when you create a
condition with the Calculation operand in the Query Panel.
Values
YES
Default
13.1.5 EXT_JOIN
<Parameter Name="EXT_JOIN">YES</Parameter>
Specifies if the database supports outer joins. This parameter is used
by all data access drivers.
Description
2012-03-15161
PRM parameter reference