PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/20/2011 6:47 PM by  Bob
Performing Calculations within PFI
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Bob
IT Support
Ash City
Basic Member
(13 points)
Basic Member
Posts:7


Send Message:

--
10/20/2011 6:47 PM
    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.