Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Windows NT > Conditional FTP from Batch File

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Conditional FTP from Batch File

Reply to Message Icon

Name: Rupali
Date: July 17, 2003 at 22:43:25 Pacific
OS: Nt 4.0
CPU/Ram: 1/1GB
Comment:

I need to achieve following :

connect scott/tiger@mydb
select flag from mytable;
if flag = 'Y' then
FTP
else
Do nothing
End if;

I want to do all this in a batch file
which I will schedule to run after every
20 mins.

Any help would be appreciated.

Thanks in advance!!!
Rupali




Sponsored Link
Ads by Google

Response Number 1
Name: Jane Williams
Date: July 24, 2003 at 03:36:04 Pacific
Reply:

Hi Rupali,
Can you get the database to create a file if the flag is set? You should be able to create a spool file.....

You could get the batch script to check for the existence of the spool file. Then delete the file after the ftp i.e.

if exist spoolfile.txt call ftp -s:ftpscript
if exist spoolfile.txt del spoolfile.txt

Hope this helps!
Jane


0
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Windows NT Forum Home


Sponsored links
Ads by Google


Results for: Conditional FTP from Batch File
Reboot from Batch file? www.computing.net/answers/windows-nt/reboot-from-batch-file/8837.html

close nt dos windows from batch files www.computing.net/answers/windows-nt/close-nt-dos-windows-from-batch-files/18837.html

SMTP from a batch file www.computing.net/answers/windows-nt/smtp-from-a-batch-file/16828.html