Midrange Systems Design - IBM i5 tm Software
| Download | Program Source |
Copy spool file to PC for Spread Sheet
Copy Print to download file. www.5-10.com 8/21/00 20:15:19
for user............... STEVE
F1=Help, F3=Exit
|
Type in the user and press enter.
Select spool entries to build SPOOLC7 EAST009A STEVE
1 of 2 8/21/00 20:17:05
Sequence..............
I=Inquire B=Build V=View
| Seq File User Pages Date Time S Copies Job
| Name t Name
| s
B 1 PRT198A STEVE 3 8/21/00 194437 RDY 1 EAST009A
_ 2 PRT198A STEVE 3 8/21/00 194837 RDY 1 EAST009A
_ 3 PRT198A STEVE 3 8/21/00 195837 RDY 1 EAST009A
_ 4 QPJOBLOG STEVE 1 8/21/00 200437 RDY 1 QPRTJOB
_ 5 QPJOBLOG STEVE 1 8/21/00 200737 RDY 1 QPRTJOB
Bottom
F3=Exit F5=Refresh F10=ViewFwrd F9=ViewBack F12=Previous PageFw F24=More
COPYRIGHT, MIDRANGE SYSTEMS DESIGN
|
Put a "B" next to the spool files to copy, press enter then F3.
Copy Print to download file. www.5-10.com 8/21/00 20:22:57
# of Heading lines to delete ___ 00=do not delete headings
Beg... End...
Pages....................... ______ 999999
F1=Help, F3=Exit
|
Remove heading and select pages, or press enter for all records
Copy Print to download file. www.5-10.com 8/21/00 20:24:43
Transfer file created
The name is: MSD04/PRINT(STEVE)
Click Receive on CLIENT ACCESS to transfer to PC.
Cut this name out, do not leave any leading or trailing spaces.
Past it to the as/400 file name
Click detail, check create new file, select ASCII Text, click OK.
Type in the PC file name, it should end with .TXT, example temp/print.txt
Click Transfer
Load EXCEL, not you can not drop the file on excel.
Click Open, select Files of Type-All file (*.*).
Find your file and click open.
Click on Fixed Width, and click next.
Each arrow will be a column on the spread sheet.
Drag the arrows to move, Click to add or delete arrows.
Click next.
Click on any column, to change the column data format.
Click finish.
F1=Help, F3=Exit
|
Use client access to transfer to a PC file