This content has been marked as final. Show 3 replies
Where you are seeing that?
In select statement like:
select distinct c1, c2, max(c3) from t1, t2 group by c1, c2.
In 10g it was
select c1, c2, max(c3) from t1, t2 group by c1, c2.
Try this - double click the Database folder in your physical layer of rpd and go to Features tab. Uncheck the value for DISTINCT SUPPORTED and save the rpd. All queries using this database will not have the distinct keyword then.
best practice: Rpd-->BMM--> Double click on Logical Source and uncheck the "Select Distinct Values" Option for the respected table.
please mark if its help you......