Performing Calculations within PFI

 0 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
Bob
Basic Member Send Private Message
Posts: 7
Basic Member
I do not know if this is the proper forum to post this question. If not, would the admins please move this question to the proper forum

I am attempting to use PFI to simulate generation of reports.  The query that PFI accepts is:
SELECT UCCUNO, UCORNO, UCIVQT, UCCUAM
FROM *LIBL.OSBSTD
WHERE UCORTP IN ('CUS','EMC') AND UCIVDT BETWEEN 20100201 AND 20100228. 

However, the actual SQL statement I want to apply to PFI is:
SELECT UCCUNO, UCORNO, SUM(UCIVQT), SUM(UCCUAM)
FROM *LIBL.OSBSTD
WHERE UCORTP IN ('CUS','EMC') AND UCIVDT BETWEEN 20100201 AND 20100228
GROUP BY UCCUNO, UCORNO

How can this be accomplished within PFI?

Thanks