Re: Loading an Informix table with data created from a mainframe extract.

> On Fri, 23 Dec 1994, L Deckard wrote: > > This question is in two parts: > > 01) < question 01 and answer deleted> > > 02) Currently, I am manually signing on to the IBM mainframe, via ftp > > <mainframe TSO IP address>, to download the extract file to the RISC 6000 box. > > I would like to automate this via a script file and fired off by cron > > everynight. What is the syntax of the ftp script file to do this. > > > > Your help would be greatly appreciated! Thanks, Lenny Deckard. > > email: ldeckard@databank.com I have a friend who has done this with AIX. You need to create a shell script somethin like this: ------------------------------ ftp -v -n hostname <<EOF user username prompt binary cd /downloaddir get download.file close quit EOF ------------------------------ Everything between the EOF(s) is passed to ftp as input from stdin. Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # #############################################################################