RE: CPYTOPCD Translation Tables

["Fisher, Don" <Dfisher@xxxxxxxxxxxxxxxxx>]

Okay, I believe I've figured this out.

The RTOPCB command doesn't really help me since it requires a transfer
description (.TTO) which also requires a drive letter to be mapped to the
AS/400.  I could theoretically map a drive letter in my batch (.BAT)
program, but there's no way of knowing the letter I select will always be
available.

As I mentioned before, this process needs to run without intervention, so
STRPCO and STRPCCMD are also out.

I think that leaves me with using CPYTOIMPF to create a delimited file,
using FTP to transfer the file to one of our servers, and then using some PC
application (Visual Basic?) to convert to a DIF or Excel format.  It doesn't
look like CPYTOSTMF or CPYTOPCD will help me as both require translation
table names that are unknown to me and don't allow delimiters to be
specified.  If anyone knows differently, please enlighten me.

Once that's done, I'm hoping it's a simple matter to send the file out via
email using an Exchange API or another VB program.

Thanks everyone.

Donald R. Fisher, III
Project Manager
The Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@roomstoreeast.com