The relational adapters have been enhanced to optimize aggregation in the presence of the FOCUS PCT function (which has no direct SQL counterparts) to SQL SUM(). Note that:

• The percentage itself is not optimized (there is no SQL equivalent) and it is calculated by FOCUS based on the obtained SUMs.
• The SQL HAVING clause is not (and must not be) generated in the presence of a PCT.
• HOLD FORMAT SAME_DB does not (and cannot) be used. It will result in FOC2634 HOLD FORMAT SAME_DB CANNOT BE PERFORMED.