Re: Dump File

["Norm Dennis" <wmss@xxxxxxxxxxxx>]

I did this recently.

To produce from a query and assuming that you are using a PC with CAE and have
access to an IFS (QDLS) drive on the AS/400
1.    Write the query output to a physical file.
2.    CPYTOIMPF to a .TXT file in the IFS with parm FLDDLM(X'05') (Hex TAB
Delimited).
3.    OPEN excel then from the File Menu click Open and select the .TXT file
from your IFS drive location.
4.    Allow Excel to convert the TAB delimited file to Excel format.

If you need to copy an existing spool file:
1.    CPYSPLF the existing report to a physical file.
2.    If you need to strip out any data, use query to select the required data
and write to another file
3.    CPYTOIMPF to a .TXT file in the IFS
4.    OPEN excel then from the File Menu click Open and select the .TXT file
from your IFS drive location.
5.    Allow Excel to convert the TAB delimited file to Excel format.

Beware that you are limited to an 8 char file name plus the .txt in the IFS.

EG.
CPYTOIMPF  FROMFILE(B604USRF/YOURFILE) +
                          TOSTMF('QDLS/YOURFLDR/YOURFILE.TXT') +
                          MBROPT(*REPLACE) RCDDLM(*CR) +
                          FLDDLM(X'05')

HTH

Norm


----- Original Message -----
From: <bbutler@usf.com.au>
To: <BPCS-L@midrange.com>
Sent: Monday, 22 October 2001 13:13
Subject: Dump File




Can anyone please tell me if there is or what is the correct way to dump a
spooled file from a Query report in "Geen Screen" into a Excel spreadsheet
please ....
We are currently using BPCS Ver 6.0.0.44_17"

Regards
                 BaB

Confidentiality Note:  This e-mail message and any attachments to it are
intended only for the named recipients and may contain legally privileged and/or
confidential information.  If you are not the intended recipients, please do not
duplicate or forward this e-mail message and immediately delete it from your
computer.


_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
or email: BPCS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.