DB2-1065-00-E DISTINCT invalid or used more than once in a statement

Either the DISTINCT keyword is invalid as used, or it appears more than once in a statement.

Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.

Resolution:

Check syntax for valid usage of the DISTINCT clause and remove any duplicate DISTINCT clauses. For example, a program may have a DISTINCT clause in one area, as well as a select statement such as COUNT (DISTINCT columnname).