PM400 screen to print

325 pts.
Tags:
AS/400 printing
CSV
IBM iSeries
PM/400
V5R4M0
PM400 option Print performance report displays the screen (below) to allow the user to drill down.  This screen is a summary with interval of 15 minutes for a 24 hour period.  I would like to copy the data lines (all entries for 24 hour period) data down to an Excel file (or .csv).   Unfortunaltely, I cannot see an easy way to do that.  Currently, customer is using copy/paste and want'ed this automated.   Any brillient solutions?  I program in RPG & CL.  (I omitted the last column that in not needed).  Thanks. ---                             Select Time Intervals                                                                                                             Library . . . . . :   QXXXDATA      Performance data . . . . . :   Q007123406                                                                                 Type options, press Enter.                                                       1=Select                                                                     O                                           Int    High        Pool            p                Transaction  -CPU Util--  Feat  --Util--  -Fault/Sec-         t  Date   Time   Count  Resp  Tot Int Bch  Util  Dsk Unit  Mch User ID       07/01  00:15    921  0,49   16   6  10     1    3 0001   13   54 02      07/01  00:30   1221  0,25   13   4   9     1    5 0035    5   65 02      07/01  00:45   1345  0,34   16   8   8     5    3 0035    2   33 02      07/01  01:00    877  0,22    7   3   4     1    2 0034    0    6 02      07/01  01:15    832  0,15    7   1   6     0    2 0001    4   23 02      07/01  01:30   1064  0,19    6   2   4     1    2 0034    1    7 02      07/01  01:45   1129  0,17    7   1   6     0    3 0025    1   14 02      07/01  02:00   1117  0,09    4   0   4     0    2 0025    2    3 02      07/01  02:15    541  0,11    5   0   5     0    2 0025    1   16 02      07/01  02:30    578  0,31    5   1   4     0    2 0025    2   10 02                                                                          More...                                                                                 F3=Exit                    F5=Refresh                    F12=Cancel            F13=Sort (date/time)       F14=Sort (count)              F24=More keys        

Software/Hardware used:
iSeries V5R4M0

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can do a WRKOBJPDM LIB(QMPGDATA) OBJ(*ALL) page down until you come to the PF, find the one you want to work with, take option 12, and and select the member. You can also use SQL or QRY to list what you need to show on the report.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following