AS/400, BPCS, show only totallines (with all information), summirazid on ILQTY from the SIL-file
Good afternoon,
I made a query with some files like SIL, SSM and IIM. Now I want to summarize on quantities of sales (ILQTY, SIL-file) but other field (like 6 more or so) still need to be showed with only the totals per item (ILPROD).
In my overview I get only Productitem and quantity summarized, but my other fields from the SIL, SSM and IIM files disappear, while I still need to see them.
How can I do that?
Thank you very much!
Rgds,
David
Software/Hardware used:
I made a query with some files like SIL, SSM and IIM. Now I want to summarize on quantities of sales (ILQTY, SIL-file) but other field (like 6 more or so) still need to be showed with only the totals per item (ILPROD).
In my overview I get only Productitem and quantity summarized, but my other fields from the SIL, SSM and IIM files disappear, while I still need to see them.
How can I do that?
Thank you very much!
Rgds,
David
Software/Hardware used:
ASKED:
May 7, 2010 12:25 PM
UPDATED:
May 7, 2010 11:07 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
What query product are you using? Query/400? Query Manager? Straight SQL? (ODBC?) Something else…?
Maybe an easier question is — How do you get to the point of creating a query? That should tell us which product it is, if you don’t know the answer.
Can you run a STRSQL command? …or STRQM command?
It sounds like you have defined a query and then executed it as a summary run. However, this has caused values from detail lines to disappear (because detail values aren’t part of a summary.) You want to know how to include certain non-summary values in your summary output.
Tom