DB2 SQL-Error: -127
SQLState: 42905
Short Description: DISTINCT IS SPECIFIED MORE THAN ONCE IN A SUBSELECT
The DISTINCT qualifier can be used only once in a SELECT statement or a subselect. Note: This message is still issued with Version 8 prior to New Function Mode.System action: The statement cannot be executed. Programmer response: The implied function is not supported by DB2. Refer to Chapter 4 of DB2 SQL Reference for information about restriction on the use of hte DISTINCT qualifier.