Re: CPYTOPCD Translation Tables

Depending on what kind of "file" you are trying to copy, you might
try CPYTOSTMF and CPYFRMSTMF -- copy to/from stream file. A "stream file" is
what IBM calls any file in an IFS directory. (Much better than the old QDLS
file system.)

----- Original Message -----
From: "Fisher, Don" <Dfisher@roomstoreeast.com>
To: <midrange-l@midrange.com>
Sent: Wednesday, August 14, 2002 5:40 AM
Subject: RE: CPYTOPCD Translation Tables


> While meandering through the archives and manuals I discovered RTOPCB.  I
am
> currently figuring out how to invoke it from the AS/400.
>
> I hadn't really thought about it, but I guess I could use FTP to send a
file
> and invoke the OLE processes or a VBA program, which I assume stands for
> Visual Basic for Access (might have to learn that language :)).  Of
course,
> that doesn't solve the problem of automatically sending the file via
e-mail.
>
> By the way, we do have CPYTOIMPF on our V4R5 machine, so I could use that
if
> all else fails.  I've been searching the V4R5 manuals for something a
little
> cleaner than file transfers and CPYTOIMPF, but have had no luck so far.
>
> Thanks.
>
> Donald R. Fisher, III
> Project Manager
> The Roomstore Furniture Company
> (804) 784-7600 extension 2124
> DFisher@roomstoreeast.com
>
> <clip>
> Command is RTOPCB. This has various output formats, including DIF, et al.
> Does this help?
>
> I know you don't have it - but CPYTOIMPF can also put
> out a tab-delimited file.
>
> Does the file have packed fields? Even so, if it does,
> create a logical that redefines those fields as zoned
> (reference technique), then FTP that logical to the PC.
> It might be possible to do all this with VBA, then call
> Excel methods (OLE) to convert the data, then email it
> to a list of clients.
> <clip>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>