L127: Distinct is specified more than once in a subselect.

See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -127, for information.