Product specifications

WHEN: indicates a WHEN clause is used. This is the default value for

IBM Red Brick databases.

QUALIFY: indicates a QUALIFY clause is used. This is the default value

for Teradata databases.

Note:

Refer to your documentation database to find how it implements the

SQL clause.

Values

See values above.Default

Related Topics

• ANALYTIC_FUNCTIONS

13.1.2 ANALYTIC_FUNCTIONS

<Parameter Name="ANALYTIC_FUNCTIONS">RANK,SUM,AVG,COUNT,MIN,MAX</Parameter>

Lists the analytic functions supported by the database.Description

See values in the PRM files.Values

The listed values.Default

13.1.3 CONSTANT_SAMPLING_SUPPORTED

Specifies if the database supports random sampling. Random sampling

consists in extracting random rows from a dataset.

Description

2012-03-15160

PRM parameter reference