RE: CPYFRMIMPF

Mark - good points

I think the source file thing was for CPYFRMSTMF, not CPYFRMIMPF - the former lets you use only a source PF or a single-column PF.

I should have said formatted PC-style files. Nonetheless, I think it still stands that stream files generally are not put into physical files.

The OP was clearly asking about an XLS file. CSV's and tab-delimited and fixed format are all importable, of course.

Regards
Vern

-------------- Original message ----------------------
From: "Murphy, Mark" <MurphyM@xxxxxxxxxx>

The problems with the question!

1. You probably CAN use CPYFRMIMPF to copy something from a library,
just that no one does it. The reason it MIGHT be possible is, that
you CAN refer to a library object using path naming, as is done with
non-library objects - things off of /root. <<

Sure you can, it can even be a source file. In fact, originally, a source file
was the only option
for this command.

2. No one puts PC-style files in a library object - that is not the

purpose of library objects. <<

Not True! Source files work fine for holding what would normally be text files
on a PC. If your
company doesn't use the IFS, and you can't get them to open it up, the source
files work well.

3. CPYFRMIMPF will do you NO good when run against an Excel file,

because those files have special structured data that the command
will not convert to a physical file. <<

And it will not work against a Word or Access file either. Because these are
not CSV files. However,
if you save your Excel data as a CSV, and it really is in a format that can
readily be converted to a
table (take the column headings out). CPYFRMIMPF can indeed work for you.

This e-mail transmission contains information that is intended to be
confidential and privileged. If you receive this e-mail and you are not a named
addressee you are hereby notified that you are not authorized to read, print,
retain, copy or disseminate this communication without the consent of the sender
and that doing so is prohibited and may be unlawful. Please reply to the
message immediately by informing the sender that the message was misdirected.
After replying, please delete and otherwise erase it and any attachments from
your computer system. Your assistance in correcting this error is appreciated.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.