-127 DISTINCT IS SPECIFIED MORE THAN ONCE IN A SUBSELECT

Explanation
 The DISTINCT qualifier can be used only once in
a SELECT statement or a subselect.

System action
 The statement cannot be processed.

Programmer response
 The implied function is not supported by DB2®.

SQLSTATE
 42905