15.4.6 Executing a query among multiple agents
When using the GROUP BY clause or ORDER BY clause to execute a query among multiple agents, the result is returned for each agent.
For example, when you collect data from Agent A and Agent B as follows, the collected result sets are returned as a group of separately sorted results for Agent A and Agent B. A result set for Agent A and Agent B is not sorted.
SELECT record-id_DATE, ... from ... where ...record-id_PROD_INST='A' and record-id_PROD_INST='B' ORDER BY record-id_DATE