Performing Calculations within PFI

 0 Replies
 0 Subscribed to this topic
 13 Subscribed to this forum
Sort:
Author
Messages
Bob
Basic Member
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