[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: FTP Problem



Hi Raghu,

This can be a really late reply, but here is my bit of suggestion.

You may refer to the ftp manual ("man ftp") for this. I suggest having a
.netrc file in the home directory of the user the script is running
under. This way, you won't be asked for a username and pass while
ftp'ing.
Just write the command as :

   $ftpCommand = 'printf put report.lis\n\nbye\n\n' || ' | ftp
servername.com '

and call this command using the "call system using $ftpCommand"

that should do the trick!!

HTH

Vishal Nayak.

Chittari, Raghuram wrote:
>
> Hi all ,
>
> I'm  working on extract sqr's which basically creates a flat file on
> Unix Environment ;
>  we do an FTP manually to put the file in to the destination drive ;
> then the respective load sqr will load the data on to the target
> database ...which is all nothing
> but conversion of  data from database to another (both on Unix);
>
> I would like to know whether we can incorporate the FTP procedure in the
>
> sqr program itself by using CALL SYSTEM USING command ;
>
> Thanks in advance ,
>
> Raghu
>
>   ------------------------------------------------------------------------
>
>    Part 1.2       Type: application/ms-tnef
>               Encoding: base64