KFAA30127-E
"DISTINCT" is specified more than once in a query specification. (reason = aa....aa, query number = bb....bb) (M+J+O)
DISTINCT cannot be specified more than once in a single query specification.
- aa....aa: Cause of the error
-
-
SELECT DISTINCT: The SELECT DISTINCT and DISTINCT set functions are both specified. <SQLSTATE: 42716>
-
different column name: Multiple DISTINCT set functions containing different column names in the arguments are specified. <SQLSTATE: 42717>
-
value expression: Another DISTINCT set function is specified in addition to the DISTINCT set function specified in the value expression of an argument. <SQLSTATE: 42718>
-
- bb....bb: Position number of the query that specified DISTINCT
-
For details about query position numbers, see 1.5 Query position numbers.
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Correct the SQL statement.