|
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 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.