Performing Calculations within PFI

Sort:
You are not authorized to post a reply.
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

    You are not authorized to post a reply.