RE: Dump File

[Sonny Kim <Sonny.Kim@xxxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Assuming you are using AS/400 Query and IBM Client Access Emulator try
following.

At AS/400 Query:
At "Select output type and output form" select output type to a "3=Database
file".
Create new file and put it to a desire library.
Run the report.

At IBM Client Access Emulator (down load to Excel can be done for any AS/400
files)
Select "Receive File From Host" (this is located as a "Recv" icon or located
under "Transfer" drop down)
Type File name: Library/QueryFile
You can define "Data Options.." for more SQL filter.
Save to a directory.

At Excel
You'll see a icon which look like an open book or will find "Transfer Data
from AS/400..." under "Data" drop down.
Click on it, "Browse..." and find the save file from above.
Click "OK" and you'll have your down load.

If you have any problem with this direction, feel free to contact me direct.

Regards,
Sonny Kim
sonny.kim@mail.cone.com


-----Original Message-----
From: bbutler@usf.com.au [mailto:bbutler@usf.com.au]
Sent: Monday, October 22, 2001 1:13 AM
To: BPCS-L@midrange.com
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.