Home > IT Answers > AS/400 > PM/400e
SILVARB
440 pts.
 PM/400e
AS/400, AS/400 performance, PM/400, QMPGDATA
Hi friends. How can I generate report like this http://www-03.ibm.com/systems/i/support/pm/pdf/FeeReport.pdf using EXCEL selecting the files on the lib QMPGDATA ? Regards to all, SILVARB

Software/Hardware used:
ASKED: July 1, 2008  1:48 PM
UPDATED: July 3, 2008  2:46 PM
RELATED QUESTIONS
Answer Wiki:
You can write a Query off of the QAPMJOBL file in QMPGDATA library and save to an outfile, then transfer the file into Excel.
Last Wiki Answer Submitted:  July 1, 2008  3:25 pm  by  Tpinky   4,165 pts.
All Answer Wiki Contributors:  Tpinky   4,165 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi Silvarb,

I need to do something like this as well. Unfortunately I’m useless with excel and even worse with getting graphics out of excel. If / When you get something like this working, can you let me know how you did it?

Thanks in advance,

Martin Gilbert.

Gilly400
 23,625 pts.
 

First write you query.

File . . . . . . . . . QAPMJOBL
Library . . . . . . QMPGDATA
Member . . . . . . . . *FIRST
Format . . . . . . . . QAPMJOBR

….+….1….+….2….+….3….+….4….+….5….+….6….+….7….+….8….+….9….+…10….+…11…
Interval Elapsed Subsystem Job
Interval date interval Subsystem library Job Job Job accounting Job
number time seconds name name name user number code type
1 030819113715 14 QSYSWRK QSYS QYPSJSVR QYPSJSVR 061587 B
1 030819113716 16 QSYSWRK QSYS QYPSJSVR QYPSJSVR 061587 B
1 030819113902 121 QSYSWRK QSYS CRTPFRDTA QSYS 061583 B
1 030819114014 193 QUSRWRK QSYS QRWTSRVR QUSER 061572 B
1 030819114500 480 PDDISKPROB V

Send to a database file…

In some cases, you can go into Excel and pull directly from you iSeries. Other cases you may have to use Client Access transfer to transfer the file to your PC as a .CSV file and then pull into Excel.

What I do in some cases, due to data not being clear is to send to a spool file, use iSeries Navigator to send to my PC in a .TXT file, open the file with Excel and convert text to table.

TPinky

Tpinky
 4,165 pts.