X080: Only one DISTINCT clause allowed per query.
XDB Server only allows one DISTINCT clause per query. For example, you cannot:
Restriction:
This topic applies to Windows environments only.
SELECT count(distinct sno),count(distinct pno) FROM partsupp
Parent topic:
X050 - X099