RE: 400 report to PC file

["Goodbar, Loyd (AFS-Water Valley)" <LGoodbar@xxxxxxxxxxxxxx>]

Then again, if the user generated the report, they could use OpsNav and copy
the report to their desktop. It automagically creates a .TXT file with the
report inside. Assuming you use CAE and OpsNav.

Loyd

-----Original Message-----
From: Jim Langston [mailto:jimlangston@conexfreight.com]
Sent: Tuesday, December 26, 2000 10:52 AM
To: MIDRANGE-L@midrange.com
Subject: Re: 400 report to PC file

/snip/

Sidebar:
I sometimes do a lot of conversion from spool files to PC files.
I find it is a relatively simple approach requiring but a few steps:

1. Locate the Job Name, Job Number and User Name.
2. Do a CPYSPLF specifying the Job Name, Job Number and User Name, and
   specify the physical file as one I already have created in a library 
   just for this purpose.  Pick a member name fairly at random.  In this
   case JIMCONEX/SPOOLIT.  This file is a flat 133 column file with no DDS.
3. FTP this file To a PC, or FTP it from the AS/400.  Whichever is easiest
   at the time.

At this point the file is almost always opened in Excel.  Open Excel, File
Open, select the file, and then pick the columns.  Fairly important to find
each date field and specify them as dates.  Otherwise Excel does some very
strange things with dates.  12/13/99 = 0.009324009 (12 divided by 13 divided
by 99).  12/13/00 I think would give a division by zero error.

Regards,

Jim Langston

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---