× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: 400 report to PC file
  • From: Jim Langston <jimlangston@xxxxxxxxxxxxxxxx>
  • Date: Tue, 26 Dec 2000 08:52:18 -0800
  • Organization: Pacer International

Short answer:
No.  There is no path to a spool file.

Bit longer answer:
As it has been explained to me before on this list, a spool file 
does not exist in a physical file.  There is not place you can 
locate it in DASD (realistically we know that it must exist on 
the disk units somewhere, we just can't get to it).

Also, OS/400 wouldn't let you access it anyway.  For security reasons.
Would you want someone to be able to find the salary report on the AS/400
and print it out?

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

Date: Sat, 23 Dec 2000 02:20:44 EST
From: MacWheel99@aol.com
Subject: Re: 400 report to PC file

<SNIP>

But so far I have not been able to give my PC guru a specific path he can use 
to get at a spool file report like say
QSYS /
LIBRARY that contains the *OUTQ /
JOB# of the user that created the report /
USER name involved /
SESSION name or JOBQ name /
FILE name assigned by the program /
DOCUMENT FILE# of the report within the JOB# /
MEMBER if relevant

Are there any such navigational directions?

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax 
interactive & batch) @ http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies - fax # 812-424-6838
+---
| 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
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.