RE: Best Way to get Excel data to AS/400

[thomas@xxxxxxxxxxx]

Well, if a direct FTP can be done, then maybe the best way is via
NFS. Just read the file from where it resides. (Or CPY it to a
local directory.)

Tom Liotta

On Thu, 25 July 2002, midrange-l-request@midrange.com wrote:

> If your database files on the 400 have no packed fields, and the
> Unix files
> are fixed length, you're in clover. Just ftp to the physical
file.
>
> Otherwise, if you can get some kind of delimited file on the
Unix
> box, ftp
> to IFS, then quote rcmd cpyfrmimpf withe the appropriate
> separators. And
> I'm sure there's a way to do a for each kind of thingy in bash
or
> csh or
> whatever. Or perl. Or maybe sed or awk.
>
> At 01:59 PM 7/24/02 -0700, you wrote:
> >I'm torn between FTP and cpyfrmimpf after saving the Excel
files
> in an IFS
> >directory in your favorite text format.  FTP might be
marginally
> easier to
> >script. If there's a lot of files involved, the real
annoyance
> will be
> >keying in all the from and to names correctly and building
the
> destination
> >files if they're not there already.  I've never used the
Synapse
> file
> >transfer.  Is it great grandchild of ETU?
> >
> >Is there a way to eliminate the middle person and get text
files
> directly
> >from the Unix box?  That would be my fantasy first choice.
FTP
> into
> >intermediate file in IFS or direct to database file.

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788
Fax  253-872-7904
http://www.400Security.com
___________________________________________________
The ALL NEW CS2000 from CompuServe
 Better!  Faster! More Powerful!
 250 FREE hours! Sign-on Now!
 http://www.compuserve.com/trycsrv/cs2000/webmail/